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 is the difference between having and a where in sql?

1151

give the syntax of grant and revoke commands? : Sql dba

1218

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1140

How much does sqlite cost?

1094

How does postgresql compare to "nosql"?

1086

How do I start sql profiler?

1048

Does mysql_real_escape_string prevent sql injection?

995

What is varray in pl sql?

1121

what are properties of a transaction? : Sql dba

1135

which tcp/ip port does sql server run on? : Sql dba

1083

Explain the working of primary key?

1154

what is log shipping? : Sql dba

1166

Can we alter stored procedure?

1043

What is the use of function "module procedure" in pl/sql?

1237

Describe sql comments?

1113