A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answer Posted / laks
select * from emp where rownum<121
minus(select * from emp where rownum<101)
| Is This Answer Correct ? | 34 Yes | 4 No |
Post New Answer View All Answers
Which table is left in left join?
How many row comparison operators are used while working with a subquery?
What are %type and %rowtype for?
What is a unique key and primary key and foreign key?
Explian rowid, rownum?
How does left join work in sql?
What is the difference between alter trigger and drop trigger statements?
What is difference between table and view?
What is an emotional trigger?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
How many types of triggers exist in pl/sql?
Can we commit inside a trigger?
How to return multiple rows from the stored procedure?
What is difference sql and mysql?
What is a scalar value in sql?