Need a MSSQL Query to get the datas

Question

1.17/5 (5 votes)

See more:

Dear Expert,

I need a MSSql query, to get the datas in a set.

Here is the below sample table.

ID  | Name     | Code
----------------------
1   | Emil     | AB
10  | Remu     | AD
15  | Martin   | AB
17  | Dil      | AC
31  | Nav      | AC
42  | Prv      | AB
43  | Pra      | AD
45  | Mob      | AB
57  | ILD      | AB

My sqlquery will execute in three times, Each time the query output below.

First Execution Outupt.

ID  | Name     | Code
----------------------
1   | Emil     | AB
10  | Remu     | AD
15  | Martin   | AB

Second Execution Outupt.

ID  | Name     | Code
----------------------
17  | Dil      | AC
31  | Nav      | AC
42  | Prv      | AB

Third Execution Outupt.

ID  | Name     | Code
----------------------
43  | Pra      | AD
45  | Mob      | AB
57  | ILD      | AB

Actually this is for like a paging .....

please help me

Thanks and Regards,
Dileep

Posted 18-Jun-13 6:28am

dilzz

Add a Solution

3 solutions

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)

Christian Graus · Answer 1 · 2013-06-18T11:14:00

Paging for what ? The ASP.NET controls do paging automatically and if you only have 9 records and 3 per page, that is good enough. Otherwise, you can use the TOP keyword to generate a given number of records, you can user order by to order by ascending and descending, to get records descending up to the first record, then 3 records ascending to get the three on your page. You will need to string mash SQL, you can't use a variable for a TOP value in T-SQL.

PP-Chen · Answer 2 · 2013-06-18T15:00:00

Solution 2

select top 3 *
From XX
order by ID

SQL

select top 3 *
From XX
Where ID > 15
order by ID

...

Posted 18-Jun-13 15:00pm

PP-Chen

Masoom Mir · Answer 3 · 2013-06-19T00:28:00

First Execution

SQL

declare @pageindex int;
set @pageindex=0
select top 3 * from [tablename]
where ID not in (select top (@pageindex*3) id from [tablename] order by id ) order by id

Second execution

SQL

declare @pageindex int;
set @pageindex=1
select top 3 * from [tablename]
where ID not in (select top (@pageindex*3) id from [tablename] order by id ) order by id

Third execution

SQL

declare @pageindex int;
set @pageindex=2
select top 3 * from [tablename]
where ID not in (select top (@pageindex*3) id from [tablename] order by id ) order by id

Need a MSSQL Query to get the datas

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0