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

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1383

Is left join same as inner join?

1020

what is 'trigger' in sql? : Sql dba

1011

What is the purpose of a secondary key?

899

What are the advantages of pl sql over sql?

961

Can sql developer connect to db2?

985

What is self-join and what is the requirement of self-join?

1088

What is sql*plus?

1016

How do I find duplicates in sql?

876

what is 'mysqlimport'? : Sql dba

973

what is rdbms? : Sql dba

958

How to pipe multiline string to isql?

959

What are stuff and replace function?

1015

How to use sql statements in pl/sql?

1052

What is a recursive stored procedure?

1095