Question

oracle 根据不同的节点,客户,算出某个月的某个客户的平均销售额 sql怎么写

Answer 1

select 节点,avg(销售额) from table where month='某个月' and 客户='某客户' group by 节点

Answer 2

select 客户,trunc(时间),avg(销售额) from table
group by trunc(时间),客户

Answer 3

说的不够清楚