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 are string functions in sql?

1238

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

1087

Which operator is used in query for pattern matching?

1087

How long does it take to learn pl sql?

1058

What is the usage of sql functions?

1144

What is the difference between an inner join and an outer join?

1022

How many types of privileges are available in sql?

1345

Which software is used for pl sql programming?

983

Explain the difference between sql and mysql.

1058

when is the use of update_statistics command? : Sql dba

1047

Is like operator in sql case sensitive?

1021

How does left join work in sql?

999

Does a user_objects view have an entry for a trigger?

1009

Explain the significance of the & and && operators in pl sql.

1007

what are date and time data types in mysql? : Sql dba

968