SELECT MAX(Sal) FROM EMP WHERE Sal < (SELECT MAX(Sal) FRO

how to find the second highest salary from emp table?

Question Posted / subrat

Answer Posted / subrat

SELECT MAX(Sal) FROM EMP WHERE Sal < (SELECT MAX(Sal) FROM EMP)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which join condition can be specified using on clause?

952

What is cross join sql?

917

What is the purpose of the partition table?

1049

What is the advantage of nosql?

1061

What are all types of user defined functions?

1073

Can we use having without group by in sql?

982

What is data profiling in sql?

1078

what is a trigger? : Sql dba

1028

What is a table partition?

1132

How do I edit a trigger in sql developer?

993

What has stored procedures in sql?

1066

How many sql databases can you have on one server?

1082

What is sql comments?

1074

What is sqlcommand?

1030

What is oracle sql developer?

1048