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
- 14991 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 class and object in asp.net?
What is Partial PostBack in ASP.NET?
How to disable disable browser's Back button in asp.net (JavaScript)?
How to you can limit Access to Web API to Specific HTTP Verb?
Write some code using interfaces, virtual methods, and an abstract class`
Why is the standalone environment only useful during the development process?
Explain serialization and deserialization?
What events will occur when a page is loaded?
What is the difference between mvc and asp.net? : Asp.Net MVC
What is session start?
What is difference between Lambda Expression and LINQ in ASP.NET?
To display data in a Repeater control which template you provide?
How are sessions stored?
Explain the asp.net mvc folder conventions? : asp.net mvc
Explain how caching in asp.net 2.0 is different from caching in asp.net 1.1?
