Top() in Sybase SQL??? 2

[rchandr3]

Hi Is there a way in which I retrieve the top N records from Sybase DB?

Thanks a lot,,,,

 

[dickiebird]

....Like in MS SQL Server ?
No - I don't think there is.

Dickie Bird (-)))

 

[grega]

You can do a

set rowcount n

before running the query. So

set rowcount 500
select * from table

will return the first 500 rows.

Greg.

 

[mjuell]

If you want the top10 prices from a table ie..
u can use

set rowcount10
select price from table
order by price desc

 

[solofeng]

I agree to mjuell

 

[rchandr3]

Thats wonderful grega! A Star for you.

Thanks a lot..... Thanks to mjuell and all who tried

Cheers,

Ravi