select * from (select rownum r ,a.* from emp a ) where r between 5 and 9

display records from 5 to 9 using rowid or rownum

Question Posted / chiru

5 Answers
16061 Views
Agile Software, I also Faced
E-Mail Answers

Answer Posted / chiru

select * from (select rownum r ,a.* from emp a ) where r between 5 and 9

Is This Answer Correct ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is a trigger in mysql? : Sql dba

1151

What is the difference between microsoft access and sql?

1030

Define SQL and state the differences between SQL and other conventional programming Languages?

1224

Explain what is a field in a database and record in a database?

1099

what is the difference between undefined value and null value? : Sql dba

1105

Is sql workbench free?

1005

What is error ora-12154: tns:could not resolve the connect identifier specified?

1084

How can triggers be used for the table auditing?

1071

Explain the savepoint statement.

1102

Is sql pronounced sequel or sql?

1274

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1137

What does inner join mean?

1176

explain primary keys and auto increment fields in mysql : sql dba

982

What is data abstraction in sql?

1035

How do I edit a trigger in sql developer?

1002