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

How does stored procedure reduce network traffic?

1066

What are pl sql data types?

1056

Is subquery faster than join?

1063

What is rowid in sql?

1057

what is the difference between undefined value and null value? : Sql dba

1147

What are the indexing methods?

1099

Is it possible to create the following trigger: before or after update trigger for each row?

1354

what are the authentication modes in sql server? How can it be changed? : Sql dba

1514

what is uncommittable transactions? : Transact sql

1038

Define join and name different types of joins?

1057

Will truncate release space?

992

Is not equal in sql?

1064

What are the ways on commenting in a pl/sql code?

1206

How do I get sql certification?

1018

What are the possible values for the boolean data field?

1016