Print 3 highest salary

Categories >> Software >> Databases >> MySQL
Suggest New Category

Question Posted / ankammarao.v

9 Answers
10296 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Print 3 highest salary..

Answer / manish nautiyal

select salary from table_name order by salary desc limit 3;

Is This Answer Correct ?

35 Yes

4 No

Print 3 highest salary..

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

Print 3 highest salary..

Answer / john peter

select salary from tablename order by salary desc limit 3;

Is This Answer Correct ?

6 Yes

1 No

Print 3 highest salary..

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

Print 3 highest salary..

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

Print 3 highest salary..

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

Print 3 highest salary..

Answer / satya

SELECT salary FROM emp order by ordering DESC limit 2,1

Is This Answer Correct ?

0 Yes

1 No

Print 3 highest salary..

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

Print 3 highest salary..

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

Post New Answer