MSSQL TOP n equivalent in ASE11.9.2 or later?

[AoN]

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 ASE.

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 SYBASE?


Bless!

AoN

 

[grega]

In Sybase, you can use set rowcountn to select the 1st n rows. Once you've done this, make sure do a set rowcount 0 to ensure subsequent queries return all rows.

Greg.

 

[AoN]

Oh, I forgot to mension I need to use this function in a subquery.