select * from ( select rownum r,a.* from TableName a ) where r>=10 a

How to retrieve range of 10th rows to 20 th rows from total
rows from a database table.? (Not from Dataset)

Question Posted / santosh dwivedi

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

Please Help Members By Posting Answers For Below Questions

Explain system functions or built-in functions? What are different types of system functions?

989

How do I view a procedure in sql server?

1000

Where in ms sql server is ’100’ equal to ‘0’?

1095

What is the use of keyword with encryption.

1038

What is the purpose of the tempdb database?

1011

Describe different Processing Modes offered by SSRS?

255

What are the built in functions in sql server?

995

What happens if we shrink log file in sql server?

994

wat wil hapn if we give the both read and deny read permission to user?

2112

Do you know what are the ways available in sql server to execute sql statements?

1045

What is encryption key?

132

What does top operator do?

1035

Do you know what are acid properties?

1091

How do I start sql server 2017?

948

what is the information that can be stored inside a bit column? : Sql server database administration

974