select max(sal) from table_name sal<(select max(sal) from table

how to find the second highest salary from emp table?

Question Posted / rajat

Answer Posted / rajat

select max(sal) from table_name sal<(select max(sal)
from table_name)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the usage of the distinct keyword?

1218

what are wild cards used in database for pattern matching ? : Sql dba

1137

Why do we use view in sql?

948

Is it possible to read/write files to-and-from PL/SQL?

1101

What is cursor in pl sql with examples?

1033

What are the ddl commands?

1008

What is optimistic concurrency control? : Transact sql

981

Is nosql faster than sql?

1017

what is rollback? : Sql dba

1105

Explain ddl statements in pl/sql?

1009

What is the use of partition by in sql?

994

How to run sql*plus commands in sql developer?

1151

What is the location of pre_defined_functions.

1166

What is the difference among union, minus and intersect?

1000

What is the basic form of sql query?

942