Row limiting clause clause allows sql queries to limit the number of rows returned and to specify a starting row for the return set.

1. Fetch first N rows:

2. Fetch 5 rows after offset of 4 rows

3. Fetch percentage of rows from a query:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.