SELECT* FROM history_data
WHERE ts BETWEEN '2022-01-01 06:00:00' AND '2022-12-31 07:00:00'
AND
id %
( Select FLOOR( count(id) / 50 ) FROM history_data
WHERE ts between '2022-01-01 06:00:00' AND '2022-12-31 07:00:00' ) = 0
ORDER BY id
SQL 50 items with same duration from table
Válasz