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

define join and explain different type of joins? : Sql dba

898

what is a unique key ? : Sql dba

1025

How to revise and re-run the last sql command?

1099

Why function is used in sql?

878

What does varchar include?

906

What is a temporal data type?

979

Why is normalization important?

972

What is the difference between partition and index?

923

Explain the difference between drop and truncate commands in sql?

962

Show the two pl/sql cursor exceptions.

1104

What is the use of count (*) in sql?

980

How to run pl/sql statements in sql*plus?

1021

How to select all records from the table?

1067

Explain what is a view?

997

What is the difference between execution of triggers and stored procedures?

1051