i need department wise top 2 employees salary.which logic
i will use
Answer Posted / vikas kapoor
select deptno,sal from
(select deptno,sal,row_number() over(partition by deptno orderby sal) r from emp ) where r<3
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of normalization are there?
What is synonyms?
What is pl sql package?
How many aggregate functions are available there in sql?
What are the basic sql commands?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What is oracle sql developer?
What is db journal file?
How do you concatenate in sql?
What is varchar example?
How do I restart sql?
what is heap table? : Sql dba
What are pl/sql cursor exceptions?
What are different methods to trace the pl/sql code?
Can a table contain multiple primary key’s?