记住:两者啥关系没有!!!一个排序!一个分组!
1.order by 是用于结果集排序的,一般是用在时间,序号这样子的字段上。
默认升序(所谓默认就是你只写了个order by 字段名)
升序asc(order by 字段名 asc)
降序desc (order by 字段名 desc)
2.group by是用于结果集分组的。何为分组就是根据该条件分拨呗,你男的,她女的;你成绩优,他成绩良,他成绩差等等。
一般呢group by都是配合聚合函数使用,如求和sum(字段名),求平均avg(字段名)等等。
上代码:
1.order by
a.未排序
SELECT * FROM user
b.升序:2种皆可
SELECT * FROM user order by create_time;
SELECT * FROM user order by create_time asc;
c.降序:
SELECT * FROM user order by create_time desc
2.group by
未分组时:
分组统计后:
SELECT leasee_id, count(*) as order_num FROM lease_order group by leasee_id