i need department wise top 2 employees salary.which logic
i will use
Answer Posted / shreya
select level,deptno,max(sal)
from emp
where level in (1,2)
connect byy prior sal>sal
group by level,deptno
order by deptno
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is sql keyword?
What is the difference between explicit and implicit cursors in oracle?
Explain some predefined exceptions.
What is the difference between row level and statement level trigger?
What is constant in pl sql?
What are aggregate and scalar functions?
What is union and union all keyword in sql and what are their differences?
Could you please provide oca (oracle 10g) dumps for my certification ?
Why are aggregate functions called so?
What is ttitle and btitle?
Is drop table faster than truncate?
I need a function for a train ticket reservation please answer it thanks in advance
How do you exit in sql?
What is a behavioral trigger?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints