如果查询包含，则必须在外部查询中添加行号
GROUP BY。
SET @row_num = 0;SELECt (SELECT @row_num := @row_num + 1) AS itempurchase_pre, *FROM( SELECT ... -- your original query goes here) AS T1ORDER BY itempurchase_pre
如果查询包含，则必须在外部查询中添加行号
GROUP BY。
SET @row_num = 0;SELECt (SELECT @row_num := @row_num + 1) AS itempurchase_pre, *FROM( SELECT ... -- your original query goes here) AS T1ORDER BY itempurchase_pre
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
