有T2 表中的数据，求出NAME中每组累加 / 每组总数的比例大于0.6 的id 和name

 

先分组求出每组的合计 ，在求出每组累加合计，在相除大于0.6 的符合要求

SELECT  a.ID,a.`NAME`,a.NUM
FROM
t2 a
LEFT JOIN
(SELECT name,sum(num) sum_num
FROM
t2
GROUP BY name) b
ON a.`NAME`=b.`name`
LEFT JOIN
(
SELECT id,
(
SELECT sum(NUM)
FROM t2
WHERE name=c.`NAME` and id<=c.ID) total
FROM t2 c) d
on a.ID = d.id
WHERE (d.total / b.sum_num)>0.6