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 tabulation?

935

How can change procedure in sql server?

1034

Write a sql query to get zero records from a table having n number of records?

1165

What happens if an integer is too big for int date type?

957

What are ddl triggers and types of ddl trigger?

1014

What is set nocount on and what is set nocount off?

924

Where are stored procedures in sql server?

1050

What’s the use of custom fields in report?

920

What are the differences between sql server and mysql.

1071

What is tablesample?

1087

How to create function with parameter in sql server?

1088

How can you insert values in multiple rows using one Insert statement?

1077

Can you name some of the dml commands in sql?

1009

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

989

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1027