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
How to commit the current transaction in oracle?
What is the max number of columns in an oracle table?
How to create additional tablespaces for an new database?
how to handle exceptions in post production
How to create a testing table in oracle?
How many data types are supported?
What is difference between truncate and delete?
How is it different from a normal table?
What is an oracle?
Why packages are used in oracle?
How to use "if" statements on multiple conditions?
Is rowid unique in oracle?
How to list all indexes in your schema?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Is postgres faster than oracle?