fjgfkgjfg的博客

加行号 SELECT @rownum := @rownum + 1 AS rownum, A.* FROM ( SELECT * FROM tableA) A,(SELECT @rownum := 0 ) B; 加行号并排名 SELECT @rownum := @rownum + 1 AS rownum, IF( @last = A.score, @rank, @rank := @rownum ) AS rank, @last := A.score AS last, A...