select max(sal) from emp where sal<>(select max(sal) from emp);

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

Question Posted / jebitha

Answer Posted / jebitha

select max(sal) from emp where sal<>(select max(sal) from
emp);

Is This Answer Correct ?

7 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is input buffer in sql*plus?

1217

What language is oracle sql developer?

1005

Explain the rollback statement?

1004

What does (*) mean in sql?

947

How does left join work in sql?

999

What is linq to sql?

1132

Where not exists in sql?

976

What is exit statement?

1011

How do I add a primary key to a table?

1040

What is %type in sql?

965

Explain what is rdbms?

1028

What is difference between sql function and stored procedure?

1002

Can primary key be changed?

903

what is single byte over head in oracle..?

2397

Can we create a trigger on view?

891