select max(sal) from new where sal not in(select max(sal) from new);

how to get second highest salary in SQL(as/4000

Question Posted / chandu

Answer Posted / chandu

select max(sal) from new where sal not in(select max(sal)
from new);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What packages(if any) has oracle provided for use by developers?

5813

Is sql a scripting language?

1023

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1003

What does closing a cursor do?

1328

What does := mean in pl sql?

1047

How do I order columns in sql?

1015

what are date and time intervals? : Sql dba

1063

How many tables can you join in sql?

965

What is a sql profiler?

1032

What are instead of triggers?

1046

Compare sql & pl/sql

1144

Is grant a ddl statement?

904

what is collation? : Sql dba

1158

what is a constraint? Tell me about its various levels. : Sql dba

993

Why we use join in sql?

980