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 char and varchar2 datatype in sql?

1067

What are the authentication modes in sql server? How can it be changed?

1132

How to drop existing views from a database in ms sql server?

1104

What is user-defined function?

981

How to truncate the log in sql server 2012? : sql server database administration

1293

When you use @@error and try-catch?

1050

What do you mean by data integrity?

1082

How to include date and time values in sql statements?

1090

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1172

What new changes are being made in SQL Server?

1195

How to assign null values to variables or columns?

978

How exceptions can be handled in sql server programming?

1017

Explain what is the difference between union and union all?

1012

How to transfer an existing table from one schema to another schema in ms sql server?

981

What is an index in sql?

1008