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

When is the update_statistics command used?

1182

Why sql query is slow?

1044

What is the difference between having clause and where clause?

1116

What is the purpose of design view?

1078

What is number function in sql?

1018

How is data stored on a disk?

1084

What is the difference between left outer join and left join?

1037

Can a varchar be a primary key?

1049

What is primary key secondary key alternate key candidate key?

1089

What are all the different normalization?

1087

What is recursive stored procedure?

1142

What is materialized view. What are different methods of refresh?

1443

What are database links used for?

1096

what is the difference between blob and text? : Sql dba

1064

What is record in pl sql?

1140