甲骨文组

Question

我有一个疑问：

Select To_Char(Order.Date, 'IW') As "Week No",
       Order.User As "User",
       Count(Order.OrderNo) As "Total Orders",
       Sum(Order_Totals.Qty) As "Total Items",
From Order Order,
     Order_Totals Order_Totals
Where Order.OrderNo = Order_Totals.OrderNo
And (Order.Date Between '01-JAN-15' And '31-DEC-15')
Group By Order.User

但是它抛出了错误消息：

Not a valid GROUP BY expression

我想显示每个用户今年每周创建多少订单和项目，看看http://www.techonthenet.com/oracle/group_by.php，我认为我使用的GROUP BY是正确的，但显然不是，我不知道如何分类。

Answer 1

您也必须在To_Char(Order.Date, 'IW')中添加GROUP BY。