in reply to Re: Re: The fine art of database programming
in thread The fine art of database programming
I believe that LIMIT is a DBMS-specific extension. For example...
in MS SQL Server:
in MS SQL Server:
in IBM DB2:SELECT TOP 10 col FROM table
I think the only platform independent way to do this is:SELECT col FROM table FETCH FIRST 10 ROWS ONLY
SELECT col FROM table A WHERE 10 > (SELECT COUNT(*) FROM table B WHERE A.col < B.col) ORDER BY col DESC
|
---|
In Section
Meditations