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

Define the select into statement.

1069

What are pl/sql cursors?

1062

Does normalization improve performance?

1044

What is the purpose of a sql?

985

What is difference between my sql and sql?

1084

What is sql procedures and functions?

1021

what are the drivers in mysql? : Sql dba

1030

What is sql rowcount?

1037

What is oracle sql called?

933

How many types of primary keys are there?

1047

Differentiate between pl/sql and sql?

1160

What is %type in sql?

973

How does rowid help in running a query faster?

1426

What is a string data type in sql?

1049

What is type and rowtype in pl sql?

1023