SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL) FROM EMPLOYEE

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

Question Posted / nitika

Answer Posted / nitika

SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are local and global variables and their differences?

1143

can a stored procedure call itself or recursive stored procedure? : Sql dba

1086

What is the difference between inner join and left join?

1041

What are different types of queries in sql?

1178

What is function and procedure in pl sql?

1119

What is bulk collect in pl sql?

1158

How to get list of all tables from a database?

1212

What is not equal in sql?

1196

What are sql*plus environment variables?

1155

What happens when a trigger is associated to a view?

973

What is record data type?

981

Which table is left in join?

1017

What are sql procedures?

1085

What does := mean in pl sql?

1091

Can a select statement fire a trigger?

1211