
laravel查询
aawuwuwuxx
这个作者很懒,什么都没留下…
展开
-
laravel 按日期分组查询
laravel 按日期分组查询 //按日分组查询 $time_list = Order::query()->from('order as ao') ->where($where) ->select(['ao.orderid', 'ao.create_time', \DB::raw('FROM_UNIXTIME(te_ao.create_time,"%Y原创 2021-09-22 16:59:50 · 952 阅读 · 0 评论 -
laravel 分组查询 获取最新一条数据 子查询
期望实现 SELECT * FROM (SELECT a.* FROM app AS a LEFT JOIN su s ON a.user_id = s.user_id AND a.school_id = s.school_id WHERE a.user_id = 1 ORDER BY a.id desc ) AS c group by school_id laravel 模型 查询 $s...原创 2019-08-23 22:01:20 · 6565 阅读 · 0 评论