问一下大家,Laravel 里数据查询 如何使用子查询
这个是原生的sql
SELECT
num
FROM
(
SELECT
, count() AS num
FROM
ron_orders
WHERE
created_at BETWEEN ‘2020-04-01’
AND ‘2020-06-01’
AND pay_status = 1
AND pay_code = ‘wechat’
GROUP BY
openid
) AS b
GROUP BY
num
ORDER BY
num
推荐文章: