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 do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is instant client oracle?
How would you change old and new values in an insert, delete and update triggers?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain cascading triggers.
What is the difference between substr & instr functions?
Please explain oracle left join with an example?
What are the roles of dba?
What is a tns service name?
What is a dynamic performance view in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Can we create trigger on materialized view in oracle?
what are archived logs?
What is a cognitive schema?
Point the difference between translate and replace?