select * from ( select ROW_NUMBER() over (order by tablename.columnnam

A table has 150 records. How do you retrieve 100th row to
120th row from that table ?

Question Posted / arif hussain

Answer Posted / arif hussain

select * from (
select ROW_NUMBER() over (order by tablename.columnname)as ronno,* from tablename )x
where ronno between 100 and 120

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does normalization improve performance?

980

how many ways to get the current time? : Sql dba

948

What are the two different parts of the pl/sql packages?

1025

How to select 10 records from a table?

1096

What is the purpose of a secondary key?

900

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1020

Why do we need view in sql?

932

what are the 'mysql' command line arguments? : Sql dba

1087

Which tcp/ip port does sql server run?

956

What is a join query?

906

how to rename an existing table in mysql? : Sql dba

1005

What is informix sql?

921

Why commit is not used in triggers?

992

what are the differences between binary and varbinary? : Sql dba

976

Which is better varchar or nvarchar?

933