关于oracle中的group by
有这样一张表（buy_detail），存放的是用户的购物信息，字段buyTime是购物时间，精确到秒。
现在要统计用户每天的消费情况：
select name,to_char(buyTime,’YYYYMMDD’) as ti , sum(cost)
from buy_detail
group by name,ti
from buy_detail
group by name,ti
这样做是有语法错误的，应该为：
select name,to_char(buyTime,’YYYYMMDD’) as ti , sum(cost)
from buy_detail
group by name,to_char(buyTime,’YYYYMMDD’)
from buy_detail
group by name,to_char(buyTime,’YYYYMMDD’)
[@more@]