a query to select maxmun 3 salaries of employee table
Answer Posted / kannan
select * from emp
where sal in (select max(sal) from emp
where level<=3
connect by prior sal>sal
group by level)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What privilege is needed for a user to insert rows to tables in another schema?
Give the constructs of a package, function or a procedure.
What is java oracle used for?
Where do you use decode and case statements?
How to invoke the original export import utilities?
What are dml statements in oracle?
How to Truncate Table in Oracle
What is the use of oracle?
Please explain compound trigger in oracle?
How to create an oracle testing table?
What is private procedure oracle?
What is open database communication (odbc) in oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to add a new column to an existing table with a default value?
What are data pump export and import modes?