SELECT MAX(SAL) FROM TEST_123 WHERE SAL NOT IN (SELECT MAX(SAL) FROM TEST

how to find the second highest salary from emp table?

Question Posted / vinod

Answer Posted / vinod

SELECT MAX(SAL) FROM TEST_123 WHERE SAL NOT IN (SELECT
MAX(SAL) FROM TEST_123)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is query optimization in sql?

988

what is cross join? : Sql dba

1004

What is dcl in sql?

967

Can we join more than 2 tables in sql?

1027

What is the difference between in and between in sql?

1068

Can delete statement be rollbacked?

991

What does the acronym acid stand for in database management?

1034

What is the difference between Union and Union all. Which is faster.

1405

What are hotfixes and patches?

949

How many functions are there in sql?

1042

Why cross join is used?

1084

What is sql in oracle?

1068

What do you understand by pl/sql cursors?

1092

What is scope and visibility in PL/SQL?

1210

Does access use sql?

1047