GridView 合并單元格（多列）

name	department	duty	email	proview

wkk	開發部	程序員	wkk@163.com	預覽

	資訊課	技術員		

	總經理室	稽核組員		

wnj	總經理室	稽核組員	wkk@163.com	預覽

	總務課	車輛管理員		

if object_id('tb') is not null

drop table tb

go

create table tb(name varchar(50),department varchar(50),duty varchar(50),email varchar(50),proview varchar(50))

insert into tb select 'wkk','開發部','程序員','wkk@163.com','預覽'

insert into tb select 'wkk','資訊課','技術員','wkk@163.com','預覽'

insert into tb select 'wkk','總經理室','稽核組員','wkk@163.com','預覽'

insert into tb select 'wnj','總經理室','稽核組員','wkk@163.com','預覽'

insert into tb select 'wnj','總務課','車輛管理員','wkk@163.com','預覽'



select case when row_number() over(partition by name order by orderid)=1 then name else '' end as name,

department, duty,

case when row_number() over(partition by name order by orderid)=1 then email else '' end as email,

case when row_number() over(partition by name order by orderid)=1 then proview else '' end as proview

from (

select row_number() over(order by name) as orderid,* from tb)t