Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 8220 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
How does an execution block start and end in pl sql?
What is pl sql and why it is used for?
What are pl/sql cursors?
What is Difference Between Unique and Primary Key Constraints?
Why stored procedures are faster than query?
What are all the different types of indexes?
Can we join tables without foreign key?
How is data stored in sql?
How can you create an empty table from an existing table?
What are character functions in sql?
what are sequences
How do sql databases work?
What is a mutating table and a constraining table?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
what are properties of a transaction? : Sql dba
