Question

SQL select 语句提示FROM 子句语法错误

要从dailysales表中选择如下数据，脚本如下：select shop_id ,sum(线下单数量) as aa ,sum(线上单数量) as bb ,sum(线下单总额) as cc,sum(线上单总额) as dd from dailysales.where Date>=“2015-07-01" and where Date>="2015-07-13"。提示FROM 子句语法错误。求高手指点

Answer 1

为什么要大于两个日期？大于7月13号不就是大于7月1号了吗？
如果是中间的话用between就可以
where Date between '2015-07-01' and '2015-07-13'

还有where后面不能再加where