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.
| Author |
Topic |
|
karan@talash.net
Starting Member
12 Posts |
 Posted - 2002-06-26 : 06:44:54
|
| Hi viewer,I want to fetch desired number of records from a recordset.Suppose i execute a sql query and there are 12000 records founds and i want to fetch only record no's 20 to 30 only.I tried using Limit in sql statement but that doesn't work in sql server.If u have any suggetions please pass it on.Regards Karan Bajoria |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-06-26 : 07:06:03
|
| Look at the faq's / articles?select top 10 *from (select top 30 * from tbl order by sortfld desc) as aorder by sortfld==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Retrieving desired number of records from a record