Select max(sal) From Employee where sal not in ( Select max (sal) From Emp

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

Question Posted / satheeshkumar

Answer Posted / satheeshkumar

Select max(sal) From Employee where sal not in ( Select max
(sal) From Employee)

Is This Answer Correct ?

24 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is plpgsql language?

977

which types of join is used in sql widely? : Sql dba

928

Does normalization improve performance?

980

What is the process of debugging?

1001

what are the features and advantages of object-oriented programming? : Sql dba

952

List and explain the different types of join clauses supported in ansi-standard sql?

1300

What are secondary keys?

921

Is pl sql and postgresql same?

1053

What is an example of translating a date into julian format?

1038

how to get @@error and @@rowcount at the same time? : Sql dba

968

what is 'trigger' in sql? : Sql dba

1012

Explain cursor types?

955

Explain aggregate functions are available there in sql?

941

Is microsoft sql free?

1043

What is left join in sql?

1004