What is Sql Server''s equivalent to Oracle''s rowcount use in q query
-
In Oracle if I want just the first 10 records from a table I can
select * from tableA where rowcount < 11
How can I do that in Sql Server??
Thanks
Joe Murphy
-
Was having a Stupid Attack found my answer
-
and that answer was
set rowcount 10
select * from tableA
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply