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 log shipping? : Sql dba

1107

How do I view a sql database?

1016

How does one load ebcdic data? : aql loader

1163

What is type and rowtype in pl sql?

1012

Why do we need view in sql?

981

What is meant by truncate in sql?

1060

What is hibernate and its relation to sql?

1119

What are the disadvantages of not performing database normalization?

1154

What is sql*plus?

1072

How to take user input in pl sql?

1161

Do foreign keys improve performance?

1020

How to select 10 records from a table?

1153

Is coalesce faster than isnull?

964

what is a join? : Sql dba

1027

How do you update a table in sql?

983