Interested to Buy Any Domain ? << Click Here >> for more details...
if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?
- 9 Answers
- 15090 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
What is the namespace to create thread in .net?
Difference between DataGid and Girdview? Difference b/w .Net 2.0, 3.0 and 3.5 ? Diff b/w dispose & Finialize Methods?
What a diffgram is, and a good use for one?
How u refer webservices?
What are different types of api?
What is the difference between exe and dll?
Why is an object pool required?
What is the main difference between Asp.net and Vb.net?
Why is global asax is used for?
What is sdlc process?
What are the differnt types of handler in ASP.NET?
Why we are using mvc instead of asp.net? : Asp.Net MVC
How to reduce the width of textbox in editcommandcolumn of datagrid?
Explain what benefit does your code receive if you decorate it with attributes demanding specific security permissions?
Explain the different types of assemblies?
