社区微信群开通啦,扫一扫抢先加入社区官方微信群
社区微信群
SELECT a.*,COUNT(1) AS vin FROM t_iov_cartrunk_auth a
LEFT JOIN t_iov_cartrunk_auth b ON a.user_id = b.user_id
AND a.create_timd <= b.create_timd GROUP BY a.user_id,a.create_timd ORDER BY a.user_id,a.create_timd DESC
SELECT
a.*, count(1) AS rank
FROM
test a
LEFT JOIN test b ON a.category_id = b.category_id
AND a.date <= b.date
GROUP BY
a.category_id,
a.date
ORDER BY
a.category_id,
a.date DESC
如果觉得我的文章对您有用,请随意打赏。你的支持将鼓励我继续创作!