登录  注册

首页->阿里云大数据助理工程师认证(ACA)

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;

参考答案
继续答题:下一题
微考学堂微考学社

更多阿里云大数据助理工程师认证(ACA)试题

考试