Limit function in mysql allow to select records from records set

e.g select * limit 3,10 from test

fetch record in range