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 is the size of partition table?

1043

What are different types of indexes?

1008

How do I run a sql query?

1014

What is flag in sql?

1032

How do you create an update query?

960

Describe different types of general function used in sql?

1036

What is crud diagram?

946

What are expressions?

1011

how to convert numeric values to character strings? : Sql dba

1101

How many types of triggers are there in pl sql?

1066

Define join and name different types of joins?

1006

How do you optimize a stored procedure in sql?

950

tell me about various levels of constraint. : Sql dba

1035

How is debugging done?

972

What is the sql*loader? : aql loader

1051