比如：
id count
1111 2222
3333 4444
5555 6666
我的sql：
CREATE VIEW dbo.View_select2
AS
SELECT e.planID,e.PlanCode, CASE WHEN c.smzt1 = 1 AND
c.smzt1date IS NOT NULL AND smzt1date <> '' THEN '已结束声明' WHEN c.smzt1 IS NULL OR
smzt1 = '' THEN '检查中' END AS [SMZT1], CASE WHEN b.taskid IN
(SELECT taskid
FROM firstchecktbl) THEN
(SELECT taskcode
FROM firstchecktbl
WHERE taskid = b.taskid) WHEN b.taskid IN
(SELECT taskid
FROM tasktbl) THEN
(SELECT taskcode
FROM tasktbl
WHERE taskid = b.taskid) END taskcode, a.factorycode AS factorycode, a.factoryname AS factoryname, d .levelmanage AS levelmanage, a.sqfpdwdz AS sqfpdwdz,
a.qfrq AS qfrq,
/*-检查日期以收费单签发日期代替,*/ (SELECT innerusername
FROM (SELECT taskid, innerusername = stuff
((SELECT ',' + isnull(innerusername, '')
FROM t_auditor
WHERE taskid = t .taskid AND groupleader_yn = 'yes' FOR xml path('')), 1, 1, '')
FROM t_auditor t
GROUP BY taskid) b
WHERE b.taskid = c.planid) AS innerusernameZZ,
(SELECT innerusername
FROM (SELECT taskid, innerusername = stuff
((SELECT ',' + isnull(innerusername, '')
FROM t_auditor
WHERE taskid = t .taskid AND groupleader_yn = 'no' FOR xml path('')), 1, 1, '')
FROM t_auditor t
GROUP BY taskid) b
WHERE b.taskid = c.planid) AS innerusernameZY, a.sqfpdwmc AS sqfpdwmc, /*-收取发票单位名称*/ a.sqfprxm AS sqfprxm, a.sqfprdh AS sqfprdh, a.jcf AS jcf,
a.nj AS nj, CONVERT(int, jcf) + CONVERT(int, nj) AS total, a.memo AS memo, e.yszkqr AS yszkqr
FROM t_costinfo a, t_costinfotask b, t_checkinfo c,
(SELECT fcodea, levelmanage
FROM t_factory
WHERE fcodea IS NOT NULL
UNION
SELECT fcodev, levelmanage
FROM t_factory
WHERE fcodev IS NOT NULL) d, PlanTbl e
WHERE a.costid = b.costid AND b.taskid = c.taskid AND a.factorycode = d .fcodea AND c.PlanID = e.PlanID
UNION
SELECT z.planid,z.planid, CASE WHEN z.smzt1 = 1 AND z.smzt1date IS NOT NULL AND smzt1date <> '' THEN '已结束声明' WHEN z.smzt1 IS NULL OR
smzt1 = '' THEN '检查中' END AS [SMZT1], z.taskcode AS taskcode, substring(z.taskcode, 6, 7) AS factorycode, CASE checktype WHEN 1 THEN
(SELECT factoryname
FROM firstchecktbl
WHERE taskid = z.taskid) WHEN 2 THEN
(SELECT factoryname
FROM plantbl
WHERE planid = z.planid) END factoryname, CASE WHEN substring(z.taskcode, 6, 1) = 'A' THEN
(SELECT max(levelmanage)
FROM t_factory
WHERE fcodea IS NOT NULL AND fcodea <> '' AND fcodea = substring(z.taskcode, 6, 7)) WHEN substring(z.taskcode, 6, 1) = 'V' THEN
(SELECT max(levelmanage)
FROM t_factory
WHERE fcodev IS NOT NULL AND fcodev <> '' AND fcodev = substring(z.taskcode, 6, 7)) END levelmanage, NULL, NULL,
(SELECT innerusername
FROM (SELECT taskid, innerusername = stuff
((SELECT ',' + isnull(innerusername, '')
FROM t_auditor
WHERE taskid = t .taskid AND groupleader_yn = 'yes' FOR xml path('')), 1, 1, '')
FROM t_auditor t
GROUP BY taskid) y
WHERE y.taskid = z.planid) asinnerusernameZZ,
(SELECT innerusername
FROM (SELECT taskid, innerusername = stuff
((SELECT ',' + isnull(innerusername, '')
FROM t_auditor
WHERE taskid = t .taskid AND groupleader_yn = 'no' FOR xml path('')), 1, 1, '')
FROM t_auditor t
GROUP BY taskid) x
WHERE x.taskid = z.planid) AS innerusernameZY, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
FROM t_checkinfo z
WHERE taskid NOT IN
(SELECT taskid
FROM t_costinfotask)
我要实现的效果就是：如果plancode重复就只显示一行，然后其他列正常显示。
求解。
