Answers for "how to use limit and top in sql oracle"

SQL
1

oracle limit rows

SELECT * 
FROM   sometable
ORDER BY name
OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;
Posted by: Guest on May-15-2020
-1

How to display top 50 rows?

In MySQL, top 50 rows are displayed by using this following query:
SELECT * FROM
LIMIT 0, 50;
Posted by: Guest on December-22-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language