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

21 Answers
27419 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1019

how to use in conditions? : Sql dba

992

what are the properties and different types of sub-queries? : Sql dba

1013

How many sql statements are used? Define them.

1018

How do I partition in sql?

942

Why truncate is faster than delete?

1088

What is aggregate function in sql?

1020

How is use pl and sql?

1048

Is sqlite free?

949

Is sql a scripting language?

973

Does truncate remove indexes?

1008

What is the use of primary key?

995

What are the different sql languages?

1022

Difference between global and parameter variables?

1948

What are all ddl commands?

1065