SQL计数顺序从GOB开始

Question

我

我有一个小问题，我每天匹配一些文件来更新我的数据库。我想数一下我从1个月开始每天在我的表“订单”上以"GOB“开始的订单数量。

id|last_update
gogo2132|27/08/2013 00:00:00
gob00000|27/08/2013 00:00:00
gob00001|27/08/2013 00:00:00
gob00002|27/08/2013 00:00:00
gob00003|28/08/2013 00:00:00

我需要的结果

Day|count"only id start by gob)
27/08/2013| 3
28/08/2013| 1

谢谢

Answer 1

我认为你正在遵循代码。

Select count(*),order_date From Table
Where Left(id,3) = 'Gob' And DateDiff(d,order_date,getdate()) <= 30
Group by order_date

Answer 2

SELECT orderdate, COUNT(*)
FROM `ORDER`
WHERE orderid LIKE 'GOB%'
GROUP BY orderdate
ORDER BY orderdate DESC

如果orderdate不包含时间，这将是一天的计数。

Answer 3

SELECT orderdate, COUNT(*)
FROM `ORDER`
WHERE orderid LIKE 'gob%' AND last_update= (SELECT NOW() - INTERVAL 1 MONTH)
GROUP BY DAY(last_update)