Question

求统计当天及当天和30天内订单数和总金额的SQL语句

订单日期是orderdate 门店为store 订单数orders 总金额total
格式如下
id 订单日期 门店 订单数 订单总金额
1 2011-4-2 A 100 10000
2 2011-4-1 A 80 8000
3 2011-3-31 A 90 9000
请教高手...谢谢...

Answer 1

oracle: select sum(orders),sum(total) from table where orderdate between sysdate-30 and sysdate;
sql: select sum(orders),sum(total) from table where orderdate between dateadd(dd,-30,getdate()) and getdate();

Answer 2

当天
select sum(订单数) from TB_table
where orderdate = (Select CONVERT(varchar(100), GETDATE(), 23))

Answer 3

按天：select orderdate,sum(orders),sum(total) from table group by orderdate