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

What kind of join is join?

975

what is self-join? : Sql dba

1169

What is identity column in sql server?

1054

What is sql and how does it work?

1178

What is write ahead logging in sql server?

1055

Mention what does the hierarchical profiler does?

1093

What is embedded sql what are its advantages?

1044

What are tuples in sql?

1138

How can we make an if statement within a select statement?

1015

What is indexes?

1062

Can a composite key be null?

981

What is trigger in flip flop?

1007

What is date functions?

1034

What is the difference between having clause and where clause?

1063

How to run sql*plus commands in sql developer?

1162