select max(salary ) from emp table where sal<(select max (salary)from e

how to find the second highest salary from emp table?

Question Posted / gayathri

Answer Posted / gayathri

select max(salary ) from emp table where sal<(select max
(salary)from emp table)

Is This Answer Correct ?

754 Yes

97 No

Please Help Members By Posting Answers For Below Questions

What is the need of merge statement?

1037

what is the use of set statement in tsql? : Transact sql

1008

Does sql between include endpoints?

1001

What is a native sql query?

1066

Explain what is a column in a table?

1105

How many sectors are in a partition?

1076

What is secondary key?

932

What are different types of queries in sql?

1121

Can we create a trigger on view?

891

If a cursor is open, how can we find in a pl/sql block?

1165

How do I run sql profiler?

1062

does sql support programming? : Sql dba

1037

How do I run a pl sql program?

1127

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

1046

Can cursors be part of a trigger body?

1638