Javatpoint Logo

91-9990449935

 0120-4256464

Javatpoint Logo

SQL ORDER BY LIMIT

We can retrieve limited rows from the database. I can be used in pagination where are forced to show only limited records like 10, 50, 100 etc.

LIMIT CLAUSE FOR ORACLE SQL:

If you want to use LIMIT clause with SQL, you have to use ROWNUM queries because it is used after result are selected.

You should use the following code:

This query will give you 21th to 40th rows.





Share this page

facebook twitter google plus pinterest tumbler

Latest 4 Tutorials