mysql把一个查询结果当作一个子集来查询

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;