How to select maximum two values using LIMIT in MySQL?

Question

I have the database in MySQL like this

id employee_id  salary
1    1          10000
2    2          20000
3    3          10000
4    4          40000
5    5          30000

I want to select the maximum two salary by using LIMIT.So how to select that?

eggyal · Accepted Answer · 2012-07-26 09:46:12Z

6

Just sort your results in descending order of salary and limit the resultset as desired:

SELECT * FROM mytable ORDER BY salary DESC LIMIT 2

See it on sqlfiddle.

answered Jul 26, 2012 at 9:46

eggyal

127k18 gold badges221 silver badges245 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mahesh Patil · Accepted Answer · 2012-07-26 09:50:00Z

1

SELECT 
  employee_id,
  salary 
From
  employee 
order by salary desc 
limit 2 ;

answered Jul 26, 2012 at 9:50

Mahesh Patil

1,5511 gold badge11 silver badges22 bronze badges