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 drop a stored procedure in oracle?
How to create an oracle database manually?
Is the After report trigger fired if the report execution fails ?
How to connect asp pages to oracle servers?
What is an oracle table?
Is there a combination of "like" and "in" in sql?
Can the query output be sorted by multiple columns in oracle?
What is rowid and rownum in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Which is faster join or subquery in oracle?
What is Virtual Private Database in Oracle?
How to resolve name conflicts between variables and columns?
IS it possible to built the oracle database without setting the kernal parameters?
What is backup in Oracle?
Explain oracle left join with an example?