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 information is maintained within the msdb database? : Sql server administration

968

how many triggers you can have on a table? : Sql server database administration

973

Why do you need a sql server?

1098

What do you understand by the data quality services in sql server?

944

Is null in sql server?

980

Explain trigger and trigger types?

963

What is sql server replication? : sql server replication

977

do views contain data ?

957

How can you check the level of fragmentation on a table?

1040

Explain trigger and its types?

1063

What is bit data type?

1034

How to find out what is the default collation in a database?

1116

What are four major operators that can be used to combine conditions on a where clause?

1039

When would you use it?

988

define and explain the differences between clustered and non-clustered indexes.

1193