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

How to return multiple rows from the stored procedure?

526

What are the types of variable use in pl sql?

567

What is sqlservr exe?

482

What is the difference between an inner and outer join?

543

What are sql triggers used for?

515

What is trigger in pl sql with examples?

525

Can a select statement fire a trigger?

664

Can we rollback truncate?

544

What does the base_object_type column shows in the user.triggers data dictionary view?

578

How do I count duplicates in sql?

552

how to drop an existing table in mysql? : Sql dba

560

What are pl sql procedures?

522

what is transaction? : Sql dba

534

What is left inner join in sql?

521

How can we optimize a sql query?

580