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

Write SQL queries on Self Join and Inner Join.

1159

How to generate random numbers with the rand() function in ms sql server?

1155

What command is used to create a database in the sql server and how?

1182

Why use “pivot” in sql server?

1122

How to create a new table in a given schema?

1190

Can sql server be linked with other servers like oracle?

968

What is fill factor and pad index?

1016

How many non clustered indexes there can be on table ?

920

Does group by or order by come first?

962

What are user-defined functions (udfs) in sql server?

993

How do I uninstall sql server 2014?

940

Are all views updatable ?

1154

What stored by the msdb? : sql server database administration

1008

What is the current pricing model of SQL Azure?

104

How to create a stored procedure with a statement block in ms sql server?

1070