select max(sal) from emp where sal!=(select max(sal) from emp where sal!=(

Find out the 3rd highest salary?

Question Posted / jagdish

Answer Posted / jagdish

select max(sal) from emp where sal!=(select max(sal) from
emp where sal!=(select max(sal) from emp))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is it possible to update views?

1005

What are character functions in sql?

990

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1028

What is where clause in sql?

1086

Can we join 3 tables in sql?

1104

What is normalization sql?

1110

Why is %isopen always false for an implicit cursor?

1150

what is a trigger in mysql? Define different types of trigger. : Sql dba

1112

how to rename an existing column in a table? : Sql dba

1075

Why is there a need for sqlcode and sqlerrm variables?

1101

What is bind reference and how can it be created?

1066

what is an index? : Sql dba

1039

What is bulk compiling in pl/sql.?

1187

Does a primary key have to be a number?

1002

Is sql low level language?

1064