sql中group by使用

2022-12-20 15:13:00 阅读:1 编辑
select *,count(*) as order_count, from_unixtime(create_time, '%Y-%m-%d %H:%i:%S') as create_time_str from ims_zhyshop_sun_xx  where  create_time >= 1671206400 GROUP BY order_id order by order_count desc