orderby与groupby同时使用方法
1.
选择销售。baobeiname,count (*)作为sales
from sales
group by sales。baobei name order by count(*)desc;
2.
选择销售。鲍贝名称,SUM (*)作为销售总额
按销售分组。鲍贝名字按总和排序(*)desc;
1.
选择销售。baobeiname,count (*)作为sales
from sales
group by sales。baobei name order by count(*)desc;
2.
选择销售。鲍贝名称,SUM (*)作为销售总额
按销售分组。鲍贝名字按总和排序(*)desc;
0条评论