sql - TSQL，如何对行进行分组？

Question

在 SQL Server 2008 中，我得到以下结果:

 contact  phone       address    email
 Name1    435551123     
 Name1                street 1  
 Name1                           name1@domain.com
 Name2    654987624
 Name2                street2   
 Name2                           name2@domanin.com

我想像下面这样“压缩”它:

 contact  phone       address    email
 Name1    435551123   street 1   name1@domain.com       
 Name2    654987624   street2    name2@domanin.com

Answer 1

尝试查询

select
contact,
max(phone),
max(address),
max(email)
from table_name
group by contact

<强> SQL Fiddle