select deptno,sal from (select deptno,sal,row

i need department wise top 2 employees salary.which logic
i will use

Question Posted / vikas kapoor

17 Answers
31535 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are all different types of collation sensitivity?

978

What is multiple partition?

921

What is foreign key sql?

948

What is difference between inner join and self join?

1031

What is loop in pl sql?

985

What is pl sql quora?

1075

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3949

How many aggregate functions are available there in sql?

931

What's the procedure?

871

What is compilation error in pl sql?

922

Explain architecture of sql server notification services?

991

What is the difference between pl and sql?

1040

what is rollback? : Sql dba

1025

Is drop table faster than truncate?

943

What is dense_rank in sql?

918