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

How can you know if the row fetched from cursor is still valid in underlying table?

751

What is sql language?

712

Does a specific recovery model need to be used for a replicated database? : sql server replication

701

what is database replicaion? : Sql server database administration

807

What is an example of a primary key?

687

What is a partition key?

667

What is a domain constraint give an example?

774

What are the methods used to protect against sql injection attack?

795

Can group by and orderby be used together?

758

What are the differences between web role and worker role?

116

What is a trace frag? Where do we use it?

828

What is NOT NULL Constraint in sql server 2012?

740

What is an expression in ms sql server?

718

Define msdb database?

785

What is the difference between DATETIME2 and DATETIME?

794