<Tr> <Td> SELECT SKIP 20 FIRST 10 * FROM T order by c, d </Td> <Td> Informix (row numbers are filtered after order by is evaluated . SKIP clause was introduced in a v10. 00. xC4 fixpack) </Td> </Tr> <Tr> <Td> SELECT TOP 10 * FROM T </Td> <Td> MS SQL Server, SAP ASE, MS Access, SAP IQ, Teradata </Td> </Tr> <Tr> <Td> SELECT * FROM T SAMPLE 10 </Td> <Td> Teradata </Td> </Tr> <Tr> <Td> SELECT TOP 10 START AT 20 * FROM T </Td> <Td> SAP SQL Anywhere (also supports the standard, since version 9.0. 1) </Td> </Tr>

A select command without a where clause return