select * from employees e where (select count(salary) from employees wher

Query for second maximum salary in each in each department

Question Posted / arvind kumar

Answer Posted / arvind kumar

select * from employees e where (select count(salary) from
employees where salary >=e.salary)=2;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is sql entity?

526

What is multiple partition?

535

Why do we use set serveroutput on?

508

how to create a new table in mysql? : Sql dba

544

Compare sql & pl/sql

600

Why is a primary key important?

537

what are aggregate and scalar functions? : Sql dba

546

Why do you partition data?

528

What is sql engine in oracle?

513

How do I start pl sql?

486

How many triggers can be applied to a table?

592

explain the advantages and disadvantages of stored procedure? : Sql dba

529

What does <> sql mean?

528

How do I run sql profiler?

577

When is the explicit cursor used ?

584