下面这样试试:
SELECT COUNT(*) AS sumcount, max(CONVERT(varchar(7), LogAddtime, 120)) AS yue, ItemID
FROM dbo.CubeViewLogs
WHERE (CustomerID = '-1')
GROUP BY CONVERT(varchar(7), LogAddtime, 120), ItemID order by ItemID,sumcount desc
SELECT COUNT(*) AS sumcount, max(CONVERT(varchar(7), LogAddtime, 120)) AS yue, ItemID
FROM dbo.CubeViewLogs
WHERE (CustomerID = '-1')
GROUP BY CONVERT(varchar(7), LogAddtime, 120), ItemID order by ItemID,sumcount desc
FROM dbo.CubeViewLogs
WHERE (CustomerID = '-1')
GROUP BY CONVERT(varchar(7), LogAddtime, 120), ItemID order by ItemID,sumcount descSelect
A.*
From
#T A
Inner Join
(Select ItemID, Max(yue) As yue From #T Group By ItemID) B
On A.ItemID = B.ItemID And A.yue = B.yueDrop Table #T
FROM dbo.CubeViewLogs
WHERE (CustomerID = '-1')
GROUP BY CONVERT(varchar(7), LogAddtime, 120), ItemID order by ItemID,sumcount descSelect
A.*
From
#T A
Where yue = (Select Max(yue) As yue From #T Where ItemID = A.ItemID)Drop Table #T