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

Why stored procedures are faster than query?

1079

Why join is faster than subquery?

1159

Define implicit and explicit cursors.

1206

What is the difference between functions, procedures, and packages in pl/sql?

1091

what are the 'mysql' command line options? : Sql dba

1133

What is t sql in sql server?

1130

what is online transaction processing (oltp)? : Sql dba

1038

Is it possible to update views?

1006

what is sql? : Sql dba

1069

How can we store rows in PL/SQL using array?

1268

What is bitemporal narrowing?

1370

Explain how exception handling is done in advance pl/sql?

1045

Explain how to use transactions efficiently : transact sql

1017

Explain sql data types?

1143

What are primary key and foreign key and how they work?

1015