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

How does sql store data?

957

What is triggering circuit?

1105

What is a pdo connection?

1113

What is a full join?

1042

What is sql server and ase?

1066

Define the select into statement.

1108

what are the 'mysql' command line arguments? : Sql dba

1186

What is the purpose of normalization?

1084

Can unique keys be null?

949

What is difference between sql and mysql?

1188

Is trigger a stored procedure?

979

Is oracle and sql same?

1074

What is a data manipulation language?

1071

What is the purpose of my sql?

1008

Which sql statement is used to return only different values?

1053