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 what is it unwise to create wide clustered index keys?

1023

How can you append an identity column to a temporary table?

1030

How to change the data type of an existing column with "alter table" statements in ms sql server?

1035

What are the properties and different types of sub-queries?

1050

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1086

How can you tell if a database object is invalid?

1114

What is Command line parameters in PLSQL.?

1184

What is a livelock?

1015

Where sql server usernames and passwords are stored in a sql server?

1036

Explain four layers of abstraction microsoft architectured?

147

Difference between primary key and clustered index?

1060

What the different components in replication and what is their use?

997

Can we call future method from queueable?

1097

How to use clusters?

1014

How much is a sql server license?

1009