Print 3 highest salary
Answers were Sorted based on User's Feedback
Answer / manish nautiyal
select salary from table_name order by salary desc limit 3;
Is This Answer Correct ? | 35 Yes | 4 No |
Answer / priya
select top 1 salary from ( select top 3 salary from ( select
distinct salary from employee order by desc ) order by asc);
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / john peter
select salary from tablename order by salary desc limit 3;
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / m gangadhar
select * from (select a.* from employees a order by
a.salary desc) where rownum <= 5
Is This Answer Correct ? | 7 Yes | 5 No |
Answer / saraswathi muthuraman
SQL> desc emp_test;
Name
-----
EMP_NO SAL
DEP_NO
SQL> select * from emp_test;
1001 10000 11
1001 10000 11
1002 100 11
1003 20010 11
1004 99 11
1005 50 11
1006 25 11
SQL> select a.EMP_NO,a.SAL,a.DEP_NO from emp_test a, (select
SAL,rank() over(order by sal desc) as rank_val from emp_test
group by sal)b where
2 a.sal=b.sal and b.rank_val =3;
1002 100 11
1 row selected.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / saraswathi muthuraman
The previous post is to find the 3rd highest value.
Please find the below qry to find the top 3 highest salary
SQL> select a.EMP_NO,a.SAL,a.DEP_NO from emp_test a, (select
SAL,rank() over(order by sal desc) as rank_val from emp_test
group by sal)b where
2 a.sal=b.sal and b.rank_val <=3;
1003 20010 11
1001 10000 11
1001 10000 11
1002 100 11
4 rows selected.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / satya
SELECT salary FROM emp order by ordering DESC limit 2,1
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / lokesh das
Using a single query not sub-query
SELECT * FROM `employee` ORDER BY salary DESC LIMIT 2, 1
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / ankammarao.v
select min(EmpSal) as sal3 from EmpInfo
where EmpSal in(select distinct top 3 EmpSal from Empinfo
order by EmpSal desc)
Is This Answer Correct ? | 7 Yes | 15 No |
Can we write pl sql mysql?
How do I connect to a mysql database?
What is RMS Migrations
how to find 2nd highest salary in random database salary of employer.....
Is oracle better than mysql?
How can we convert between Unix & MySQL timestamps?
What are date and time data types in mysql?
How do I completely remove mysql from windows?
how to declare unique key in creating a table..?
What is heap table?
How many columns is too many mysql?
How To see all the tables from a database of mysql server.