<Tr> <Td> SELECT FIRST 10 * FROM T order by a </Td> <Td> Informix </Td> </Tr> <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>

How to write select query with where in sql