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

      Write a Reply...