Want to get groups of 100 records

I can get the top 100 records by

select top 100 LastName from clientinformation

is there any way to get the 201 - 300th record 301 - 400th record and so on ....

Thanks
Charles BaldoSoftware DeveloperAsked:
Who is Participating?
 
käµfm³d 👽Connect With a Mentor Commented:
How about:
// 200 - 300
SELECT TOP 100 LastName FROM clientInformation
WHERE LastName NOT IN (SELECT TOP 100 LastName FROM clientInformation)

// 300 - 400
SELECT TOP 100 LastName FROM clientInformation
WHERE LastName NOT IN (SELECT TOP 200 LastName FROM clientInformation)

// 400 - 500
SELECT TOP 100 LastName FROM clientInformation
WHERE LastName NOT IN (SELECT TOP 300 LastName FROM clientInformation)

etc.

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.