Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anu
select *
FROM (select emp1.* ,rownum rnum
from ( select * from emp order by sal_amount desc ) emp1
where rownum<=3)
where rnum >=3
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is procedure function?
What is procedure in pl sql?
Can triggers stop a dml statement from executing on a table?
What is the usage of sql functions?
Give the order of sql select?
Define commit, rollback and savepoint?
What are the disadvantages of not performing database normalization?
What is int identity in sql?
What is rowtype?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Which one is faster ienumerable or iqueryable?
Is pl sql useful?
What are the different types of triggers?
How would you pass hints to the sql processor?
What is the difference between a query and a report?
