Fetching

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

Select Top N is your best bet.

Andy

rampm SSC Journeyman Points: 76 More actions · Answer 2

Thanx Andy,

But i think u didnt get my question?

Specific number of records say from 400 to 450.HOw can i fetch?

thiruna SSC Enthusiast Points: 135 More actions · Answer 3

SELECT * from <tablename>

WHERE recid between 400 and 450

Hope this may help u....

Thiru

Andy Warren SSC Guru Points: 119902 More actions · Answer 4

If you have a consistent record id column that would work. Take a look at these two articles (be sure to read both!):

Andy

Cookies on SQLServerCentral