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 / m

Answer Posted / m

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

Is This Answer Correct ?

222 Yes

39 No

Please Help Members By Posting Answers For Below Questions

What is sqlcontext?

1086

What does rownum mean in sql?

1027

What is the sql*loader? : aql loader

1053

How do you update sql?

981

Can we enter data in a table in design view?

969

What is raid? How does it help storage of databases?

1087

How do I sort a table in sql?

1048

define sql delete statement ? : Sql dba

1022

What is scalar function in sql?

1041

Explain autonomous transaction.

1157

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1006

Which sql statement is used to return only different values?

1004

What is a procedure in pl sql?

1212

what is sql server agent? : Sql dba

1109

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1002