select max(sal) from employeedata where sal

Find out the 3rd highest salary?

Question Posted / ritesh sabanis

Answer Posted / ritesh sabanis

select max(sal) from employeedata where sal <
(select max(sal) from employeedata where sal not in(select
max(sal)from employeedata)) ;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why self join is used in sql?

966

How to assign sql query results to pl sql variables?

1050

What is the difference between nvl function, ifnull function, and isnull function?

1089

What is procedure explain with program?

999

What is cursor explain with example?

966

Define concurrency control. : Transact sql

1157

How many sql statements are used?

1004

What is embedded sql with example?

1020

How can we implement rollback or commit statement in a trigger?

1019

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1096

What is an ndf file?

977

what is 'mysqld'? : Sql dba

960

What is raw datatype in sql?

1030

Why should I use postgresql?

1000

what is the difference difference between procedure and packages

10365