How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)
Answer Posted / santosh dwivedi
select * from
(
select rownum r,a.* from TableName a
)
where r>=10 and r<=20
| Is This Answer Correct ? | 14 Yes | 10 No |
Post New Answer View All Answers
Explain system functions or built-in functions? What are different types of system functions?
How do I view a procedure in sql server?
Where in ms sql server is ’100’ equal to ‘0’?
What is the use of keyword with encryption.
What is the purpose of the tempdb database?
Describe different Processing Modes offered by SSRS?
What are the built in functions in sql server?
What happens if we shrink log file in sql server?
wat wil hapn if we give the both read and deny read permission to user?
Do you know what are the ways available in sql server to execute sql statements?
What is encryption key?
What does top operator do?
Do you know what are acid properties?
How do I start sql server 2017?
what is the information that can be stored inside a bit column? : Sql server database administration