SELECT MAX(SALARY) FROM EMP WHERE SALARY<(SELECT MAX(SALARY) FROM EXP);

how to find the second highest salary from emp table?

Question Posted / abhishek kundu

Answer Posted / abhishek kundu

SELECT MAX(SALARY) FROM EMP
WHERE SALARY<(SELECT MAX(SALARY) FROM EXP);

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how would you enter characters as hex numbers? : Sql dba

981

How do I edit a stored procedure?

989

How does postgresql compare to oracle/db2/ms sql server/informix?

1032

What is rowid in sql?

980

Explain the difference between triggers and constraints?

968

What are the different types of database management systems?

998

How many triggers can be applied on a table?

931

Why do we use partitions in sql?

1044

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

947

What is procedure and function?

976

Explain aggregate functions are available there in sql?

1003

Is record in oracle pl sql?

958

What does seeding a database mean?

952

Are there any features that are decommissioned in 11g that are not present in 11g?

2141

what does the t-sql command ident_current does? : Transact sql

977