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

Why do we use subquery?

1006

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1085

What are the two types of exceptions in pl/sql?

1047

How do I create an index in word?

1027

What is the largest value that can be stored in a byte data field?

1012

Is not null in sql?

988

Is pl sql a programming language?

980

How do I view a view in sql?

947

Explain scalar functions in sql?

1059

What is a natural join sql?

965

Is left join and outer join same?

1052

Can we use rowid as primary key?

981

What is the difference between sql and isql*plus?

1086

What is assignment operator in pl sql?

1029

What is t sql used for?

1010