Declare @PageIndex int set @PageIndex=2 select top 20 * from (select

if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?

Question Posted / rasbeer

9 Answers
14637 Views
Mind Tree, I also Faced
E-Mail Answers

Answer Posted / rasbeer

Declare @PageIndex int
set @PageIndex=2

select top 20 * from
(select top 20 * from
(select top (@PageIndex*20) * from chat_contents order by
id ) as a1
order by id desc)as b1 order by id

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between rest and restful?

1004

What is the difference between custom web user control and a custom web server control?

905

Which is faster viewbag or viewdata?

919

Define static constructor?

953

How do you declare static variable?

973

Is asp.net mvc front end or backend? : Asp.Net MVC

880

How to you can limit Access to Web API to Specific HTTP Verb?

1148

If 200 is for all successful operation then why do we have 201 response codes?

862

What does occur first in ASP.Net, Authentication or Authorization?

985

Write a code for sending an email from asp.net application.

982

If we remove web.config or machine.config from the application then, is this application will works?

964

Can we set master page as a start page?

975

What is ispostback method in asp.net? Why do we use that?

1130

Explain the server control events of asp.net ?

941

What is the significance of ASP.NET routing?

1028