MSSQL TOP n equivalent for Informix?

AoN · Jan 14, 2002

I'm working on an application which will work against several DBMS's. I've found that if I use the MSSQL specific TOP n in one of my queries I cut time to a third.

I've been looking for an equivalent that for INFORMIX.

Basically it returns either the TOP n percent, or the TOP n rows. I need something that returns only 1 row, as TOP 1 would do.

Is there a equivalent thing for INFORMIX?

Bless!

AoN

olded · Jan 16, 2002

Hi:

Check the documentation on the informix select clause. New, with the 7.x engine, you can do something like this:

selct FIRST 2 {+FIRST_ROWS} * from some_table
where some_column = "some_value"

The above gets the first two rows.

regards,

Ed

Guest_imported · Feb 1, 2002

select max(column_name)

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

MSSQL TOP n equivalent for Informix?

AoN

Programmer

olded

Programmer

Guest_imported

New member

Similar threads

Part and Inventory Search

Sponsor