Sample Header Ad - 728x90

ANSI/ISO plans for LIMIT standardization?

12 votes
1 answer
5012 views
Are there currently plans to standardize one best way of limiting the number of results returned by a query? The stack overflow question at Is there an ANSI SQL alternative to the MYSQL LIMIT keyword? lists the various ways to handle this behavior in different languages: 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 I don't play in DBs that often so I'm speaking from ignorance here, but it seems like this is a pretty important functionality - at least important enough that I scratch my head when I see it has been left up to vendors.
Asked by chucksmash (545 rep)
Dec 14, 2012, 03:52 PM
Last activity: Sep 23, 2022, 10:04 AM