dati da un database

[salvodj]

mysql

[ttcc]

mysql

set @row:=-1;
SELECT tableName. *
FROM tableName
INNER JOIN (
SELECT id
FROM (
SELECT @row:= @row +1 AS rownum, id
FROM (
SELECT id
FROM tableName
ORDER BY id
) AS sorted
) AS ranked
WHERE rownum %3 =0
) AS subset ON subset.id = tableName.id
LIMIT 0 , 10;

dovrebbe funzionare...