SELECT *
FROM test limit 10 offset 19;
SELECT gender, row_number() over(partition by gender order by t.username)
FROM test t order by 2 limit 10;
SELECT *
FROM test limit 10 offset 19;
SELECT gender, row_number() over(partition by gender order by t.username)
FROM test t order by 2 limit 10;