SQL语法中,常用到分组和排序,下列SQL执行报错的是?
(A)select region, sum(price) as total_price from sale_detail group by 1;
(B)select region, sum(price) as total_price from sale_detail group by region;
(C)select region, price from sale_detail group by region;
(D)select region, sum(price) as total_price from sale_detail group by region order by total_price;
参考答案
继续答题:下一题