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 myisam? : Sql dba

999

What is the use of stored procedures?

973

What is materialized view. What are different methods of refresh?

1328

What is the use of partition by in sql?

927

What is error ora-12154: tns:could not resolve the connect identifier specified?

1015

What are the three forms of normalization?

992

What is nosql example?

968

Explain the rollback statement?

961

Is sql a backend?

966

What is sql architecture?

980

Can a varchar be a primary key?

952

How can we debug in PL/SQL?

1089

Is json a nosql?

914

Do we need commit after truncate?

1028

How can we solve sql error: ora-00904: invalid identifier?

1162