Hi @Sebastien F Maybe you could try this: with tablePart as (SELECT ROW_NUMBER() OVER (DISTRIBUTE BY colName SORT BY anotherColName) AS counter, t.* FROM myTableName t) SELECT * FROM tablePart WHERE tablePart.counter <= limit; First of all, I create groups of data via the distribute then I sort them by anotherColName, then I use row_number to assign a value to each row of each group as if it was a counter. Then I select that counter and all the columns of the original table where the value of the local counter is less or equal to my limit. You could add have you random data in this way: with tablePart as (SELECT ROW_NUMBER() OVER (DISTRIBUTE BY colName SORT BY rand()) AS counter, t.* FROM myTableName t) SELECT * FROM tablePart WHERE tablePart.counter <= limit; ... View more