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 does desc stand for?

1075

What are triggers in sql?

1023

What is structural independence and why is it important?

1031

What is sharding in sql?

990

Can there be 2 primary keys in a table?

997

Is t sql a programming language?

1070

Which is faster union or join?

972

How is sql used in oracle?

1010

explain access control lists. : Sql dba

1003

What will you get by the cursor attribute sql%found?

965

What is a trigger in sql?

1207

What is sql character function?

1089

How sql query is executed?

1136

What is query syntax?

976

What is recursive join in sql?

1031