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
- 14635 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 asp.net master page?
What is use of <% %> in asp.net?
What is session in http request?
Explain State management in asp.net
What is the difference between Hash table and Array list?
How many types of cookies are there in asp.net?
Define tracing.
3. What goals do you have in your career?
Differentiate between authentication and authorization.
How can we prepairing Interview
How to Separate background image and front image from original picture....
What is asp.net futures?
How to deploy/publish webservices?How many ways?Plz explain me
Where is asp.net view state stored?
Explain MVC model binders?
