hello..
how can I select only the first N rows out of of a table?
thank's in advance...Lior
Loading
hello..
how can I select only the first N rows out of of a table?
thank's in advance...Lior
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
MananPosted Sep 28, 2007, 7:35 AM
You can get first n rows like,
Select TOP 10 * from [TableName]
If you want to fetch record of only few columns then,
Select TOP 10 [col1],[col2],[col3] from [TableName]