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

How do I find duplicates in a single column in sql?

1015

Define implicit and explicit cursors.

1140

What do you understand by pl/sql cursors?

1083

how to drop an existing table in mysql? : Sql dba

1042

What is rank function in sql?

1022

What is package in pl sql with an examples?

1035

What is the difference between joins?

1037

How to avoid duplicate records in a query?

1004

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

1382

Can we use loop in sql?

967

Is the primary key an index?

1024

Explain alias in sql?

1039

What is substitution variable?

1047

What does t sql mean?

941

What is update query?

973