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
- 15344 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
Contrast OOP and SOA. What are tenets of each ?
How asp.net mvc differs from asp.net web forms? : asp.net mvc
Disable Mouse right click on web page in asp.net?
What is the server of asp.net?
What do you mean by serialize?
is there any third party tools are using in .net technologies? what are there ? give me the brief introduction?
What is the page life cycle in asp.net?
What are the different types of Caching techniques in ASP.NET?
Explain weak typing and strong typing.
How do http sessions work?
How do you identify that the page is postback?
What is the maximum number of classes that can be contained in one dll file?
What is asp.net and how it works?
What is viewstate? In which event of the page life cycle, is the viewstate available?
Can we use a static function with a non-static variable?
