22,207
社区成员
发帖
与我相关
我的任务
分享
SELECT
A.station,
A.itemid ,
CONVERT(VARCHAR(10),B.jw_date ,120)AS TIME,
COUNT(B.*)AS 个数
FROM
stationinfo A JOIN minutedata B
ON A.station=B.station
AND A.itemid =B.itemid
GROUP BY
A.station,
A.itemid ,
CONVERT(VARCHAR(10),B.jw_date ,120)
SELECT
A.station,
A.itemid ,
CONVERT(VARCHAR(10),B.jw_date ,120)AS TIME,
COUNT(B.*)AS 个数
FROM
stationinfo A JOIN minutedata B
ON A.station=B.station
AND A.itemid =B.itemid ]
GROUP BY
A.station,
A.itemid ,
CONVERT(VARCHAR(10),B.jw_date ,120)
SELECT
A.station,
A.itemid ,
CONVERT(VARCHAR(10),B.jw_date ,120)AS TIME,
COUNT(B.*)AS 个数
FROM
stationinfo A JOIN minutedata B
ON A.station=B.station
AND A.itemid =B.itemid ]
GROUP BY
A.station,
A.itemid ,
CONVERT(VARCHAR(10),B.jw_date ,120)AS TIME
select
convert(varchar(10),jw_date,120) as jw_date,
count(1) as 总数
from
tb
where
jw_date
between '2009-07-01' and '2009-07-31'
group by
convert(varchar(10),jw_date,120)
--这样?
select
convert(varchar(10),jw_date,120) as jw_date,
count(1) as 总数
from
tb
group by
convert(varchar(10),jw_date,120)