SELECT MAX(average) AS Expr1 FROM sp WHERE (average NOT I

how to find the second highest salary from emp table?

Question Posted / subahar

Answer Posted / subahar

SELECT MAX(average) AS Expr1
FROM sp
WHERE (average NOT IN
(SELECT MAX(average) AS Expr1
FROM sp AS sp_1))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is compound trigger?

1106

Is record in pl sql?

1013

What are the advantages of indexing?

1030

what is the difference between join and union? : Sql dba

1204

can sql servers linked to other servers like oracle? : Sql dba

1054

Do foreign keys improve performance?

1068

Are subqueries faster than joins?

1077

What does rownum mean in sql?

1091

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1057

What does dml mean?

1043

How many commands are there in sql?

1091

Is sql developer case sensitive?

1048

Is sql similar to python?

1043

What is mutating table error?

1240

What are all ddl commands?

1131