62,046
社区成员
发帖
与我相关
我的任务
分享
SELECT CityCode,CityCaption
,convert(varchar,year(ChangeDateTime))
+'-'+convert(varchar,month(ChangeDateTime))
+'-'+convert(varchar,day(ChangeDateTime))
+'-'+cast(datepart(hh,ChangeDateTime) as varchar)
AS SupplyMonth
,SUM(OccupyArea)/10000 As AreaAll
FROM [Land_BaseInfo]
WHERE (Price>0 AND Price IS NOT NULL) AND ChangeDateTime IS NOT NULL
GROUP BY
convert(varchar,year(ChangeDateTime))
+'-'+convert(varchar,month(ChangeDateTime))
+'-'+convert(varchar,day(ChangeDateTime))
+'-'+cast(datepart(hh,ChangeDateTime) as varchar)
,CityCode
,CityCaption