select last_name,salary from employees where salary = (select max(salary)

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / sanjib b

Answer Posted / sanjib b

select last_name,salary from employees where salary =
(select max(salary) from employees
where salary <> (select max(salary) from employees))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is basic structure of pl sql?

1074

What is a behavioral trigger?

979

what is data manipulation language? : Sql dba

1022

What are the subsets of sql?

1137

Which is better stored procedure or query?

958

Does varchar need length?

999

How can check sql version from command line?

1089

How to run pl sql program in mysql?

1025

Why do we need a foreign key?

1102

what is the syntax used for partition in tsql? : Transact sql

1015

What are analytical functions in sql?

1034

What is meant by cursor in sql?

1002

what are the type of locks ? : Sql dba

966

Can a table contain multiple primary key’s?

1100

What is sap sql?

988