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 calculate date and time differences in oracle?
how to clone 9i Database on to 10g Database.
What is merge in oracle?
Explain what does a control file contain?
List the various oracle database objects?
Difference between varchar and varchar2 data types?
How to start instance with a minimal initialization parameter file?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to grant create session privilege to a user in oracle?
Briefly explain what is literal? Give an example where it can be used?
What happens to the current transaction if the session is killed?
What is the difference between postgresql and oracle?
How to assign a table row to a record variable?
How to create a new view in oracle?
Explain the use of indexes option in imp command.