MYSQL 添加序列号取数

將纪录按照id 排序后，取第1,101,201,301，。。。条纪录

1:

SET @i = 0;

SELECT (@i:=@i+1) AS nid, id FROM  tbl

WHERE nid MOD 100 = 1

2:

SELECT * FROM
(
SELECT (@i:=@i+1) AS nid, tbl01.* FROM tbl,  (SELECT @i:=0) AS it 
ORDER BY sort DESC
) AS t
WHERE t.nid MOD 100 =1