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

Can a function call a stored procedure in sql server?

908

What is resultset concur_updatable?

967

How to create a view with data from multiple tables?

963

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

884

What is the purpose of the tempdb database?

957

What is the difference between an index and a unique index?

952

What is buffer cash and log cache in sql server?

1052

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

976

What is the difference between online clustering and Offline clustering?

2356

Can sql server be linked with other servers like oracle?

902

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

838

What are Spatial data types in SQL Server 2008

961

Explain primary key in sql server?

970

Find first and last day of current month in sql server

973

How to delete exactly duplicate records from a table?

1006