we have different Queries for selecting first few records as per database e.g.
for ORACLE SELECT * FROM EMP WHERE ROWNUM <100
FOR MS SQL AND SYBASE SELECT TOP 10 * FORM EMP
THEN WHAT IS FOR INFORMIX AND ODBC ?
I have found the Soln:
Its SELECT FIRST 100 * FROM EMP