Select Max(Sal) From Emp E Where E.Sal < (Select Max(Sal) From Emp)

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

Question Posted / abhay

Answer Posted / abhay

Select Max(Sal)
From Emp E
Where E.Sal < (Select Max(Sal) From Emp)

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How much does sql certification cost?

543

What is %rowtype in pl sql?

511

What's the procedure?

490

What are hotfixes and patches?

527

Why truncate is used in sql?

527

What is structural independence and why is it important?

546

What are the properties of a transaction?

559

Is big data nosql?

512

What does truncate mean in sql?

534

What is sql in java?

543

Is sql harder than python?

602

What are triggers in sql?

578

What is normalisation in sql?

551

What are crud methods?

549

Can a foreign key have a different name?

511