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

What are the different types of locks in the database?

974

Difference between report and query parameter.

1144

What is the use of group by clause?

992

What command would you use to create an index?

1107

How do you clear a log file?

1110

What is dknf in normalization form?

1112

Explain the architecture of ms sql reporting service?

970

Tell me what is difference between view and materialized view?

983

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1175

What are different types of data sources?

1084

How to view existing indexes on an given table using sp_help?

1205

What is the difference between dbcc indexdefrag and dbcc reindex?

1040

Explain the purpose of indexes?

1023

How dts is used to extract, transform and consolidate data?

1116

Explain cdc and sql injection?

1045