22,301
社区成员




SELECT id ,
CONVERT(VARCHAR(7), [time], 120) ,
COUNT(DISTINCT num) AS 次数
FROM Tab
GROUP BY id ,
CONVERT(VARCHAR(7), [time], 120);
SELECT ROW_NUMBER()OVER(ORDER BY CONVERT(VARCHAR(7), [time], 120)) AS ID,
CONVERT(VARCHAR(7), [time], 120) ,
COUNT(DISTINCT num) AS 次数
FROM Tab
GROUP BY
CONVERT(VARCHAR(7), [time], 120);
SELECT ROW_NUMBER()OVER(ORDER BY CONVERT(VARCHAR(7), [time], 120)) AS ID,
CONVERT(VARCHAR(7), [time], 120) ,
COUNT(DISTINCT num) AS 次数
FROM Tab
GROUP BY id ,
CONVERT(VARCHAR(7), [time], 120);