select max(salary) from employees where salary<(select max(salary) from

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

Question Posted / sushant hole

Answer Posted / sushant hole

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 the process of debugging?

1006

What does sign mean sql?

1022

What is the current version of postgresql?

1007

What is normalization in sql?

964

Which sql most popular?

937

Is subquery faster than join?

953

Is coalesce faster than isnull?

909

What is data definition language?

1048

What are the benefits of pl/sql packages?

1034

Write a query to find the names of users that begin with "um" in sql?

926

How is data stored in sql?

1005

What is rowid in sql?

909

How to read xml file in oracle pl sql?

862

Why we use cross join?

890

What is schema in sql?

887