select max(sal) from table_name where sal not in (select max(sal) from tab

how to find the second highest salary from emp table?

Question Posted / jayshree

Answer Posted / jayshree

select max(sal) from table_name where sal not in (select
max(sal) from table_name)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the sql aggregate functions?

1184

What are the datatypes available in pl/sql ?

1155

How do I remove all records from a table?

1119

How do I trace sql profiler?

1046

What is the size of partition table?

1093

What is the difference between stored procedure and view?

1066

How do you optimize a query?

1060

What is a data definition language?

1197

How do I remove sql developer from windows 10?

1185

What are sql built in functions?

981

What is $$ in sql?

1046

What is column?

1034

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7496

What is basic structure of pl sql?

1132

Explain lock escalation? : Transact sql

1271