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 a recursive join sql?

1072

what are the nonstandard string types? : Sql dba

1138

Which kind of parameters cannot have a default value in pl sql?

1149

How do you declare a user-defined exception?

1024

What is difference between my sql and sql?

1072

What is the example of procedure?

928

how to calculate the difference between two dates? : Sql dba

1062

How exception handling is done in advance pl/sql?

981

How do I find duplicates in sql?

929

Can one improve the performance of sql*loader? : aql loader

1048

What is a trigger in sql?

1203

What are the usages of sql?

1058

What is sqlservr exe?

977

what is table? : Sql dba

1062

How to download oracle sql developer?

1107