select second 100 rows in sql server

Question

4.00/5 (1 vote)

See more:

SQL-server-2000

SQL-Server-2005

, +

hi freinds
i have a table with 250 record , i want select 100th to 200th rows , please guide me.

Posted 5-Sep-11 22:23pm

vahid_erad

Updated 29-May-20 4:50am

Add a Solution

5 solutions

Solution 5

You can also use Linq-to-SQL for that. It is a case where it is much simpler to express the query in Linq.

C#

var query = 
    from m in dataContext.MyTable
    select m;
var result = query.Skip(100).Take(100);

Or even if you don't use it, you might get LINQPad[^], write a Linq query and then get the generated SQL code...

Posted 6-Sep-11 15:26pm

Philippe Mori

Updated 6-Sep-11 16:21pm

v3

Comments

Simon Bang Terkildsen 6-Sep-11 22:06pm

+5 for LINQ, learn it and love it :)

Solution 4

I have one tip posted which lets you select from any range of rows.

Check
How To Select Record Based on Row Number[^]

I hope this will help.

Posted 5-Sep-11 23:34pm

Abhishek Sur

Solution 2

If you are using MS SQL Server 2005 and above you can use ROW_NUMBER.

Find out more details here.
Another link.[^]

Posted 5-Sep-11 22:39pm

Suresh Suthar

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Blesson Mathew · Accepted Answer · 2011-09-05T23:29:00

Solution 3

Hi,
Use The sql Query like this,

SQL

select top(100) ClumnName from Table1 where ClumnName NOT IN (select top (100) ClumnName from Table1 )

I hope this may help you,
Thanks.

Posted 5-Sep-11 23:29pm

Blesson Mathew

v2

Comments

Toniyo Jackson 6-Sep-11 6:34am

Good answer, 5!

Joezer BH 11-Sep-13 10:50am

5ed!

I've just used it as a reference in a solution to the same problem :)

Blesson Mathew 6-Sep-11 8:11am

Thaanx Jackson

OriginalGriff · Accepted Answer · 2011-09-05T22:38:00

Solution 1

Try:

SQL

SELECT *
FROM (
     SELECT *, ROW_NUMBER() OVER (ORDER BY OrderID) AS RowNum
     FROM [Order Details]
     ) AS MyDerivedTable
WHERE MyDerivedTable.RowNum BETWEEN 100 AND 200

Posted 5-Sep-11 22:38pm

OriginalGriff

Comments

Suresh Suthar 6-Sep-11 4:40am

Nice. 5.

Joezer BH 11-Sep-13 10:52am

5ed!

I've just used it as a reference in a solution to the same problem :)

Maddy selva 25-Dec-14 2:59am

my 5+

User-12551084 7-Jun-20 14:02pm

Nice