先分组求出每组的合计 ,在求出每组累加合计,在相除大于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