如何进行这样的mysql查询？

Question

我会向你寻求帮助的。示例表：

| ID | NAME |POINT|
|  1 | alex | 2 |
|  2 | alex | 2 |
|  3 | jenn | 4 |
|  4 | shama| 3 |
|  5 | jenn | 4 |
|  6 | Mike | 1 |

我想查找重复的名称，并更改名称的值和重复值的和。喜欢

| ID | NAME     |POINT|
|  1 | alexander| 4   |
|  2 | jennifer | 8   |

是否可以进行mysql查询？谢谢。

Answer 1

尝尝这个

select id,
case when name = 'alex' then replace(NAME,'alex','alexander') 
     when name = 'jenn' then replace(NAME,'jenn','jennifer')
     end  as d,sum(point) 
     from name group by d having d is not null;

Answer 2

这是你想要的吗？

select (@rn := @rn + 1) as id, name, sum(point) as point
from t cross join
     (select @rn := 0) params
group by name
having count(*) >= 2;