删除重复行并合并单元格值mysql [英] delete duplicated row and merge cell value mysql

问题描述

我有一个包含三列的 MySQL 表:

I have a MySQL table which has three columns:

Name           | Email               | BDate
---------------------------------------------------------
John Doe       | [e-mail]    | June 1, 1980
Kelly Smith    |                     | June 2, 1983
Richmond White | [e-mail]  | 
John Doe       |                     | 
Kelly Smith    | [e-mail]  | 
Richmond White |                     | June 3, 1984

我想要做的是删除重复名称并合并单元格值.我希望我的桌子看起来像这样:

What I want to do is to delete duplicate name and merge the cell value. I want my table to look like this:

Name           | Email               | BDate
---------------------------------------------------------
John Doe       | [e-mail]    | June 1, 1980
Kelly Smith    | [e-mail]  | June 2, 1983
Richmond White | [e-mail]  | June 3, 1984

我的查询如何返回我的愿望表?

How would my query look like to return my desire table?

提前致谢！

推荐答案

查询:

SQLFIDDLE 示例

SELECT t1.Name, 
       MAX(t1.Email) Email, 
       MAX(t1.BDate) BDate
FROM Table1 t1
GROUP BY t1.Name

结果:

|           NAME |              EMAIL |        BDATE |
------------------------------------------------------
|       John Doe |   [e-mail] | June 1, 1980 |
|    Kelly Smith | [e-mail] | June 2, 1983 |
| Richmond White | [e-mail] | June 3, 1984 |

这篇关于删除重复行并合并单元格值mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！