select '第'||to_char(purchase_date,'qq')||'季度',purchase_date ,sum(quantity)
from b
where to_char(purchase_date,'yyyy')='2004'
group by '第'||to_char(purchase_date,'qq')||'季度',purchase_date
from b
where to_char(purchase_date,'yyyy')='2004'
group by '第'||to_char(purchase_date,'qq')||'季度',purchase_date
from b
where to_char(purchase_date,'yyyy')='2004'
group by '第'||to_char(purchase_date,'qq')||'季度',product_name
我模仿你的写的,可是他说group有问题,因为我这里是日文系统,所以我看不怎么懂.
行1でエラーが発生しました。:
ORA-00979: GROUP BYの式ではありません。
select '第'||to_char(purchase_chen.purchase_date,'q')||'季度' ,product_chen.product_name,product_chen.product_price*sum(purchase_chen.quantity)
from product_chen,purchase_chen
where to_char(purchase_chen.purchase_date,'yyyy')=2004 and product_chen.product_name=purchase_chen.product_name
group by '第'||to_char(purchase_chen.purchase_date,'q')||'季度',product_chen.product_name;
产品名称 1季度销售额 2季度销售额 3季度销售 4季度销售 全年合计
Small Widget
Medium Widget
Chrome Phoobar