yihua833
SSC Enthusiast
Points: 110
More actions
May 5, 2003 at 7:10 pm
#80883
i have a table with 10000 records:
id int --
content varchar
how do i use t-sql to query like
1st 20 records
3rd 20 records
9th 20 records....
5409045121009-7368
SSCoach
Points: 15740
May 5, 2003 at 7:14 pm
#456236
Previous solution on this site was
Select Top 20 *
From (Select Top 60 * from Table)
Order by Col1 Desc
A sp with @From and @To parameter.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply