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

Is sql the best database?

981

How do you identify a primary key?

1067

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1110

what is try_catch block in procedure

1755

What is pl sql architecture?

965

How to download oracle sql developer?

1118

Explain cursor types?

1032

Enlist some predefined exceptions?

1065

What is primary key in db?

1014

Is vs as in pl sql?

993

Is sql developer case sensitive?

1005

What is a join?

1075

State some properties of relational databases?

1059

What is column?

999

Is sql free?

975