I want to retrieve only specific numbers of rows from SQL Server 7.0.
Say,I wanna retrieve first 100 records.
But without using
“Set Rowcount [ ]”
How to write a query for retrieving first 100 rows of any query.
Also I would like to know about the query which can fetch only specific Range of query ie; row no. 10 to Row no. 20.
This is possible in oracle using Rownum.
How to do in SQL server 7.0.
Please help me ……………..
