这对您有用吗?
select Name, Value from table where Value in ( select distinct Value from table order by Value desc limit 3) order by Value desc
也许:
select a.Name, a.Value from table ajoin (select distinct Value from table order by Value desc limit 3) b on a.Value = b.Value



