sql查出来的表 很多数据重复 菜鸟求助

Question

select pp.productid as '产品id'
,pp.name as '产品名称'
,pp.PMEID as 'PM'
,pp.Active as '是否有效'
,pp.IsOnline as '是否上线'
,ppi.ScenicSpot as '图片名称'
,ppi.FileName as '文件名称'
,count(pp.productid)
from HHProductDB..Prd_ProductImages ppi
left join HHProductDB.dbo.prd_product pp on ppi.productid=pp.productid
where ppi.ImageCategory = 4
and pp.name not like '%测试%'
and pp.name not like '%test%'
and pp.name not like '%Test%'
and pp.IsOnline = 'T'
and pp.Active = 'T'
group by pp.productid , pp.name, pp.PMEID, pp.Active, pp.IsOnline, ppi.ScenicSpot, ppi.FileName
having count(pp.productid)<10

Answer 1

select distinct * from
(

select pp.productid as '产品id'
,pp.name as '产品名称'
,pp.PMEID as 'PM'
,pp.Active as '是否有效'
,pp.IsOnline as '是否上线'
,ppi.ScenicSpot as '图片名称'
,ppi.FileName as '文件名称'
,count(pp.productid)
from HHProductDB..Prd_ProductImages ppi
left join HHProductDB.dbo.prd_product pp on ppi.productid=pp.productid
where ppi.ImageCategory = 4
and pp.name not like '%测试%'
and pp.name not like '%test%'
and pp.name not like '%Test%'
and pp.IsOnline = 'T'
and pp.Active = 'T'
group by pp.productid , pp.name, pp.PMEID, pp.Active, pp.IsOnline, ppi.ScenicSpot, ppi.FileName
having count(pp.productid)<10
) as table_temp

Answer 2

怎么可能，你都group by了，显示的每一条记录肯定至少有一个字段的值是不同的。本回答被提问者采纳