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 is set transaction?

1044

Is stored procedure faster than query?

973

What is sql*loader?

1202

What is database migration?

977

What is a sql schema used for?

1116

How can a function retun more than one value in oracle with proper example?

1088

How can I change database name in sql?

1094

What are the two types of exceptions.

1181

What are the qualities of 2nf?

1048

Why are sql stored procedures used?

1065

When are we going to use truncate and delete?

999

Why stored procedures are faster than query?

1039

how to convert character strings to dates? : Sql dba

1073

What is use of package in pl sql?

1026

what is a stored procedure? : Sql dba

1146