表结构如下图
http://www.vs2007.cn/1.jpg
我用如下SQL语句
SELECT CONVERT(char(10), AddTime, 120) AS 日期, COUNT(*) AS 数量
FROM Comego_charge
WHERE (MONTH(AddTime) = '8')
GROUP BY CONVERT(char(10), AddTime, 120)
ORDER BY CONVERT(char(10), AddTime, 120)
得出结果为
http://www.vs2007.cn/2.jpg
求得的数据为这个月份中每一天车辆的总和
但是我还想求得这个月份中每一天不同车型的和,又要如何弄呢,比方说car_type='1'的和,car_type='2'的和
不会弄了,谢谢大家,分不够再加
http://www.vs2007.cn/1.jpg
我用如下SQL语句
SELECT CONVERT(char(10), AddTime, 120) AS 日期, COUNT(*) AS 数量
FROM Comego_charge
WHERE (MONTH(AddTime) = '8')
GROUP BY CONVERT(char(10), AddTime, 120)
ORDER BY CONVERT(char(10), AddTime, 120)
得出结果为
http://www.vs2007.cn/2.jpg
求得的数据为这个月份中每一天车辆的总和
但是我还想求得这个月份中每一天不同车型的和,又要如何弄呢,比方说car_type='1'的和,car_type='2'的和
不会弄了,谢谢大家,分不够再加
from Comego_charge
where month(addtime) = 8
group by car_type,convert(varchar(10),addtime,120)
--如果求car_type='1',car_type='2'的和select car_type,convert(varchar(10),addtime,120) 日期 , COUNT(*) AS 数量
from Comego_charge
where month(addtime) = 8 and car_type='1' and car_type='2'
group by car_type,convert(varchar(10),addtime,120)
FROM Comego_charge
WHERE (MONTH(AddTime) = '8')
GROUP BY CONVERT(char(10), AddTime, 120)
ORDER BY CONVERT(char(10), AddTime, 120)
from Comego_charge
where month(addtime) = 8
group by car_type,convert(varchar(10),addtime,120)
--如果求car_type='1',car_type='2'的和select car_type,convert(varchar(10),addtime,120) 日期 , sum(money) AS 数量
from Comego_charge
where month(addtime) = 8 and car_type='1' and car_type='2'
group by car_type,convert(varchar(10),addtime,120)
如果不是,那算我又搞错了.
COUNT(*) AS 数量,
sum(case when car_type='1' then 1 else 0 end) as car_type1的和,
sum(case when car_type='2' then 1 else 0 end) as car_type1的和
FROM Comego_charge
WHERE (MONTH(AddTime) = '8')
GROUP BY CONVERT(char(10), AddTime, 120)
ORDER BY CONVERT(char(10), AddTime, 120)
select car_type,convert(varchar(10),addtime,120) 日期 , COUNT(*) AS 数量
from Comego_charge
where month(addtime) = 8 and car_type in (1,2)
group by car_type,convert(varchar(10),addtime,120)