Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?

by

this shows the different ways:

-- DB2
select * from table fetch first 10 rows only 
-- Informix 
select first 10 * from table 
-- Microsoft SQL Server and Access 
select top 10 * from table 
-- MySQL and PostgreSQL 
select * from table limit 10 
-- Oracle 
select * from (select * from table) where rownum <= 10

More Related Contents:

  1. Implementing Comments and Likes in database
  2. How to check if mysql database exists
  3. difference between primary key and unique key
  4. How to shrink/purge ibdata1 file in MySQL
  5. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  6. Difference Between Schema / Database in MySQL
  7. How do I add a custom CHECK constraint on a MySQL table?
  8. MySQL: Cloning a MySQL database on the same MySql instance
  9. DOs and DONTs for Indexes [closed]
  10. How to change the default port of mysql from 3306 to 3360
  11. How to insert images from database?
  12. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  13. When to use MyISAM and InnoDB? [duplicate]
  14. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  15. How to insert a file in MySQL database?
  16. What does SQL Select symbol || mean?
  17. How do I rename a MySQL database (change schema name)?
  18. Foreign key to one of many tables?
  19. Find date range overlaps within the same table, for specific user MySQL
  20. Rename a table in MySQL
  21. What’s the recommended way to connect to MySQL from Go? [closed]
  22. How to store Query Result in variable using mysql
  23. How to find all the relations between all mysql tables?
  24. How to speed up sql queries ? Indexes?
  25. How to reuse auto_increment values? [duplicate]
  26. How do I alter a mysql table column defaults?
  27. Selecting distinct 2 columns combination in mysql
  28. How to store a one to many relation in MySQL database?
  29. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  30. MySQL and PDO: Could PDO::lastInsertId theoretically fail?

Leave a Comment