select rnum, d.* from dept d, (select rownum rnum , deptno from dept ) e

how to select 5 to 7 rows from a table, which contains 10 rows?

Question Posted / sajida

Answer Posted / sajida

select rnum, d.* from dept d, (select rownum rnum , deptno
from dept ) e
where d.deptno = e.deptno and rnum between 5 and 7;

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between count () and rowcount ()?

514

How do you trace the traffic hitting a sql server?

610

What is join query?

491

What is the tcp/ip port on which sql server runs?

559

Is foreign key unique?

567

Do you know what is difference between index seek vs. Index scan?

509

What is the difference between mysql and mysqli?

574

Can a table have 2 foreign keys?

497

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

526

How to get the definition of a user defined function back?

558

When to use null data driven subscription?

144

What is lookup override?

580

In what sequence sql statement is processed?

577

How to replace given values with null using nullif()?

566

What are user defined functions in ms sql server?

499