SELECT top 5 COUNT(买家) as [count],面积段 as 面积
FROM view_khfx
where FirstHandID = 2 and Convert(varchar(4),年份,120)='2007' and Convert(varchar(2),月份,101)='7' group by 买家,面积段 order by count(买家) desc如何让面积段去重复
FROM view_khfx
where FirstHandID = 2 and Convert(varchar(4),年份,120)='2007' and Convert(varchar(2),月份,101)='7' group by 买家,面积段 order by count(买家) desc如何让面积段去重复
select top 5 COUNT(买家) as [count],面积段 as 面积
from view_khfx v
where id=(select max(id) from view_khfx where v.面积段=面积段)
from view_khfx v
where Dealid=(select max(Dealid) from view_khfx where v.面积段=面积段) group by 买家,面积段 这样就挂了,慢死
你这样试试
SELECT top 5 COUNT(买家) as [count],面积段 as 面积
FROM view_khfx
where FirstHandID = 2 and Convert(varchar(4),年份,120)='2007' and Convert(varchar(2),月份,101)='7' group by 面积段 order by count(买家) desc
(
select top 5 Count(ID) IDC,Name ,ID from dbo.TestTable1
group by ID,Name order by ID
)aID:买家
Name:面积段
view_khfx : TestTable1
(
SELECT top 5 COUNT(买家) as [count], 面积段 as 面积
FROM view_khfx
where FirstHandID = 2 and Convert(varchar(4),年份,120)='2007'
and Convert(varchar(2),月份,101)='7' group by 买家,面积段
order by count(买家) desc
)
select distinct(面积),* from t