display records from 5 to 9 using rowid or rownum
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
what is a trigger in mysql? : Sql dba
What is the difference between microsoft access and sql?
Define SQL and state the differences between SQL and other conventional programming Languages?
Explain what is a field in a database and record in a database?
what is the difference between undefined value and null value? : Sql dba
Is sql workbench free?
What is error ora-12154: tns:could not resolve the connect identifier specified?
How can triggers be used for the table auditing?
Explain the savepoint statement.
Is sql pronounced sequel or sql?
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?
What does inner join mean?
explain primary keys and auto increment fields in mysql : sql dba
What is data abstraction in sql?
How do I edit a trigger in sql developer?