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

Explain subquery and state its properties?

970

Why is replication required on the sql server?

1010

What is autocommit mode in sql server?

1080

How to use copy and concatenate commands in SQL?

1066

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8109

Explain transaction server implicit?

925

what is a check constraint?

1040

Which are ddl commands?

977

What are date and time data types in ms sql server?

1021

Why use “nolock” in sql server?

985

What is xml datatype?

1035

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1163

What is the difference between cartesian product and cross join?

814

What is partition index in sql server?

1049

What is the correct order of the logical query processing phases?

876