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 / nagarjuna.reddy

Answer Posted / nagarjuna.reddy

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is stored procedure faster than query?

913

What are the parameter modes supported by pl/sql?

1016

What is delimiter in pl sql?

986

Why do we use procedures?

911

What are the 3 types of behavioral triggers?

1181

What are the types of variable use in pl sql?

1008

Which sql most popular?

934

how to see the create table statement of an existing table? : Sql dba

945

What is count * in sql?

934

What is dense_rank?

879

Is left join same as inner join?

1019

Explain 3 basic parts of a trigger.

1254

Explain constraints in sql?

979

What is the trigger in sql?

899

What is a composite primary key?

1030