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 pl sql collection?

1014

Why do we use subquery?

1073

What is the usage of the distinct keyword?

1274

How does postgresql compare to "nosql"?

1079

How sql query is executed?

1185

How can we avoid duplicating records in a query?

1031

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

1045

What is out parameter used for eventhough return statement can also be used in pl/sql?

1122

Can we use two order by clause in query?

1015

How do I order by ascending in sql?

1077

What are types of exception?

960

How do I install sql?

1043

What is sql query limit?

1016

What is cursor status?

1235

Can sql function call stored procedure?

1070