SELECT tb1.id, tb1.point
FROM table_name tb1
LEFT JOIN (SELECT DISTINCT id,point FROM table_name ORDER BY id,point DESC LIMIT 0,3) AS tb2
ON tb1.id = tb2.id
SELECT tb1.vender, tb1.best_perform
FROM table_name tb1
LEFT JOIN (SELECT DISTINCT best_perform FROM table_name ORDER BY best_perform DESC LIMIT 0,3) AS tb2
ON tb1.best_perform = tb2.best_perform
SELECT * from type_cache5 a1 where 2 = (
SELECT count(*) from (SELECT best_perform from type_cache5 GROUP BY best_perform) a2
where a2.best_perform>a1.best_perform