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

Does inner join return duplicate rows?

991

What is java sql driver?

1129

which types of join is used in sql widely? : Sql dba

985

How to Declare Fixed Length String Value In PL SQL

1158

what is bdb (berkeleydb)? : Sql dba

1038

What are the different types of dbms?

1016

Define sql delete statement.

1016

What is meant by cursor in sql?

1007

What are the different ways to optimize a sql query?

950

Which is better join or inner query?

1061

What does t sql mean?

951

What is rank () in sql?

952

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

963

what does the t-sql command ident_incr does? : Transact sql

1083

Can we use views in stored procedure?

1036