select sal from emp a where 3=(select count(distinct(sal)) from emp b whe

how to check the 3rd max salary from an employee table?

Question Posted / somanath

Answer Posted / somanath

select sal from emp a where 3=(select
count(distinct(sal)) from emp b
where a.sal<=b.sal)

Is This Answer Correct ?

34 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is a field in a database?

1066

How do you define a foreign key?

1008

how to check server status with 'mysqladmin'? : Sql dba

1078

What is pivot query?

1078

Can we join more than 2 tables in sql?

1024

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1230

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1003

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2017

How will you distinguish a global variable with a local variable in pl/sql?

1156

Explain what is an index?

1059

What is left join example?

953

What is a temporal table?

934

What does rownum mean in sql?

1030

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1069

How to return an array from java to pl/sql?

1144