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

Explain the purpose of %type and %rowtype data types?

977

What is the difference between drop and truncate commands?

1113

What is a call statement? Explain with an example.

1071

Which join is like an inner join?

1095

Name three sql operations that perform a sort.

1066

Why self join is used in sql?

1031

What will you get by the cursor attribute sql%found?

1009

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1058

What is sql*loader and what is it used for?

1222

Is it mandatory for the primary key to be given a value when a new record is inserted?

1254

what is an index? : Sql dba

1045

what are the authentication modes in sql server? How can it be changed? : Sql dba

1514

what is the difference between inner and outer join? Explain with example. : Sql dba

1067

Do we need to create index on primary key?

966

what are set operators in sql? : Sql dba

1108