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 a pragma statement?

1239

Are stored procedures compiled?

888

What does pragma mean?

1000

What are the different types of functions in sql?

1024

what are date and time intervals? : Sql dba

1018

What are all the different normalizations?

997

How do you optimize a query?

958

What is a boolean in sql?

961

What are the parts of a sql statement?

1050

What is crud stand for?

959

What is the process of copying data from table a to table b?

1065

What is trigger types in sql?

966

Write an sql query to select all records from the table?

988

Is sql considered coding?

1011

What is count * in sql?

965