SELECT *
FROM (
SELECT @row := @row +1 AS rownum, sdt_prices.*
FROM (
SELECT @row :=0) r, sdt_prices where token_id = 1 order by id desc
) ranked
WHERE rownum %5 = 1
by Valeri Tandilashvili
3 years ago
MySQL
ROWNUM
0
Pro tip: use ```triple backticks around text``` to write in code fences
