how to get top 10 rows from million records

[sridhargoshika]

Can we get top 10 rows only?

[nabeelasjid1]

You can simply add a counter, on every row data get, increase your counter by 1. when its reached to 10, return;