SELECT * FROM employees ORDER BY salary DESC LIMIT 2 , 1 its so sim

how to check the 3rd max salary from an employee table? One
of the queries used is as follows:

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

Here in the sub query "select
count(distinct(sal)) from emp b
where a.sal<=b.sal" or
"select count(distinct(sal)) from emp b
where a.sal=b.sal" should reveal the same number of rows is
in't it? Can any one here please explain me how is this
query working perfectly.

However, there is another query to get the 3rd highest of
salaries of employees that logic I can understand. Pls find
the query below.
"select min(salary) from emp where salary in(select
distinct
top 3 salary from
emp order by salary desc)"

Please explain me how

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

source:http://www.allinterview.com/showanswers/33264.html.

Thanks in advance
Regards,
Karthik.

Question Posted / aalee

4 Answers
8487 Views
I also Faced
E-Mail Answers

Answer Posted / aalee

SELECT *
FROM employees
ORDER BY salary DESC
LIMIT 2 , 1

its so simple!!!!!!

Is This Answer Correct ?

6 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a rank in sql?

970

What are the types of join and explain each?

1059

Is crud a cuss word?

1040

What is sql constant?

1040

what is datawarehouse? : Sql dba

1029

How do I make sql search faster?

1004

what is the different between now() and current_date()? : Sql dba

1031

explain the advantages and disadvantages of stored procedure? : Sql dba

1017

what is a composite primary key ? : Sql dba

1059

Can a foreign key be null?

1094

what is the difference difference between procedure and packages

10425

what is a trigger? : Sql dba

1041

What are sql constraints?

1183

What are sql objects?

1085

explain commit and rollback in mysql : sql dba

1029