how can I use limit keyword if I want middle records??

Answer 1

if you want the record starting from 3 Rd entry and you want only next 4 entries then you can use LIMIT 2,4 ..

correct me if I'm wrong.

Answer 2

very correct