Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Selecting range of records without autonumber field.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-28 : 23:54:22
Jignesh writes "Hi,

Like TOP n can I use range here say TOP n-m ? I mean if I use TOP n to select TOP n rows from a result set is there anything which will give me say 11-20 or 21-30 ?

Waiting for positive reply.

Thanks

Jignesh"
   

- Advertisement -