use this query. it works great. select max(sal) from table

how to find the second highest salary from emp table?

Question Posted / bipin

Answer Posted / bipin

use this query. it works great.

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

Is This Answer Correct ?

415 Yes

59 No

Please Help Members By Posting Answers For Below Questions

Explain raise_application_error.

1100

Can we insert in sql function?

1091

What is the current version of postgresql?

1070

What is composite primary key in sql?

999

What are the types pl/sql code blocks?

1137

what is auto increment? : Sql dba

1014

How do I quit sql?

963

what are date and time data types in mysql? : Sql dba

972

Show the cursor attributes of pl/sql.

1050

What is gpt format?

942

How many indexes can be created on a table in sql?

1055

How many joins can you have in sql?

939

What is audit logout in sql profiler?

1028

Can we use delete in merge statement?

1039

How can I see all tables in sql?

1077