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
- 14705 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / santosh
u can easily done by the use of Row_number() in sqlserver.
Ex:-
declare @Lower_Bound int,@Upper_bound int
SET @Lower_Bound=1 -- change this as per requirement
SET @Upper_bound=20 -- change this as per requirement
Select Id,Name from(select row_number()over(order by id asc) as Temp_Id,Id,Name from M_Student)
M_Student where Temp_Id >=@Lower_Bound and Temp_Id<=@Upper_bound
Here My Table Name is M_Student(Id,Name) & I have made a Temporary Id column(Temp_Id).Here the result.
Thank U......
If any query then u can connect me through
santosh.primetechsoftware@gmail.com
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is voluum?
Explain code snippet to register exception filters from controller?
If 200 is for all successful operation then why do we have 201 response codes?
What is the importance of aspnet_isapi.dll, inetinfo.exe andaspnet_wp.exe in the page loading process.
How do I force the dispose method to be called automatically, as clients can forget to call dispose method?
What are the advantages of asp.net?
14. What are your Future Plans for Swatz Oils GROUP U.K?
What is http request and response?
Explain Features in ASP.NET
What is the difference between sealed vs static class?
Why we use content place holder in asp.net?
What language does asp.net use?
How to do state management in ASP.NET?
Can you explain how ASP.NET application life cycle and page life cycle events fire?
Explain exception handling in .net.
