我需要把数据分组排序,于是就想到先group by 然后 order by,可是运行的时候报错
于是查资料发现group by 与order by 一起使用是要遵守一定原则的:
order by 的列,必须是出现在group by 子句里的列
也可以用来查询一条语句(注意数据库版本)
select * from (select distinct * from op_order_customer order by ordertime desc) a
group by receiver(有版本去掉distinct没效果)
select * from op_order_customer where ordertime in(
select max(ordertime) time from op_order_customer group by receiver)