select * from (select a.*, row_number() over (order by empno) rn from emp a

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

Question Posted / jayanth

Answer Posted / jayanth

select * from (select a.*, row_number() over (order by empno) rn from emp a) where rn between 100 and 120;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to test for null values?

1096

How to raise user-defined exception with custom sqlerrm ?

1178

Explain alias in sql?

1094

How subquery works in sql?

1128

What is a full join sql?

1103

Define union, minus, union all, intersect ?

1064

how many tables will create when we create table, what are they? : Sql dba

1114

Can variables be used in sql statements?

1073

Is there a 64 bit version of ssms?

997

What is auto increment feature in sql?

1174

Why query optimization is needed?

971

how are mysql timestamps seen to a user? : Sql dba

1192

What are sql commands?

1067

What is cartesian join in sql?

1194

What is schema in sql example?

1277