SELECT * FROM (SELECT * FROM table GROUP BY column HAVING COUNT(column)>=3 ORDER BY column DESC LIMIT 0,3) AS table_new WHERE table_new.A=table_new.B;
转载于:https://www.cnblogs.com/ai594ai/p/8855196.html
SELECT * FROM (SELECT * FROM table GROUP BY column HAVING COUNT(column)>=3 ORDER BY column DESC LIMIT 0,3) AS table_new WHERE table_new.A=table_new.B;
转载于:https://www.cnblogs.com/ai594ai/p/8855196.html