SELECT title, COUNT(art) AS art_count
FROM table1
GROUP BY art
HAVING art_count >= (select count(*) * X / 100 from table1)
您需要为插入一个值 X
Mysql仅选择行的百分比
SELECT title, COUNT(art) AS art_count
FROM table1
GROUP BY art
HAVING art_count >= (select count(*) * X / 100 from table1)
您需要为插入一个值 X