逢"1“ 取出 【此处1是指第一个轮排的ID】
SELECT id
FROM 你的表
WHERE ((id + 1) % 2 = 0) AND ({ fn MOD(id + 1, 4) } <> 0)
ORDER BY id
逢2取出
SELECT id
FROM 你的表
WHERE ((id % 2 = 0) AND ({ fn MOD(id, 4) } <> 0)
ORDER BY id
逢3取出
SELECT id
FROM 你的表
WHERE ((id + 1) % 2 = 0) AND ({ fn MOD(id + 1, 4) } = 0)
ORDER BY id
逢4取出
SELECT id
FROM 你的表
WHERE ((id % 2 = 0) AND ({ fn MOD(id, 4) } = 0)
ORDER BY id