Returning n rows from a table

[DanSeal]

Hi, i'm trying to work out how to return n number of rows from a table, where n is some number. I am not bothered what the data is, i just want to be able to return say, the top 100 rows in the table.

Thanks,

Danny

 

[r937]

it depends on which database you're running -- there are some non-standard shortcuts that are more efficient than the generic Top N approach

see FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...

http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid504195_tax285649,00.html

rudy

 

[grega]

For Sybase (and probably MS SQL Server) use

set rowcount n
select rows from table
set rowcount 0

Greg.

 

[DanSeal]

The article on techtarget did the job. Thanks guys.