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 to enter numeric values as hex numbers? : Sql dba

1064

What is a pl/sql block?

1227

Explain what is an index?

1056

what is the syntax for using sql_variant_property? : Transact sql

1044

What is parallel hint?

1326

What is the largest value that can be stored in a byte data field?

1012

How can you fetch first 5 characters of the string?

1018

What is a subquery in sql?

1040

Does db2 use sql?

946

Should I use mbr or gpt?

1026

How many indexes can be created on a table in sql?

1055

What are the usages of sql?

1058

Can we call procedure in select statement?

1055

What is Histogram?

1558

Explain the select statement in sql?

1110