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
Explain the working of primary key?
What is substitution variable?
What will you get by the cursor attribute sql%found?
What are different types of indexes?
What is a recursive join sql?
How to read/write files from pl/sql?
How to add a column ‘salary’ to a table employee_details?
Enlist the data types that can be used in pl/sql?
How many types of cursors are available in pl/sql?
What are properties of the transaction?
What are dml commands?
How sql query is executed?
what are the different type of sql's statements ? : Sql dba
What is sql basics?
How are sql commands classified?