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

What is sql profiler in oracle?

1033

What is a join?

1035

How do sql triggers work?

1002

What is orm in sql?

1015

Is and as keyword in pl sql?

928

Which join is default?

909

what is the command line end user interface - mysql? : Sql dba

941

What is the difference between in and between in sql?

1014

How do I remove sql developer from windows 10?

1041

What is cartesian join in sql?

1062

What is dml with example?

1034

Is sql developer case sensitive?

959

what is 'mysqld'? : Sql dba

933

How can you load multi line records? : aql loader

1038

What is sql basics?

1007