select rowid % 10, count(*) from nulls1 group by 1 order by 1 0|9 1|10 2|10 3|10 4|10 5|10 6|10 7|10 8|10 9|10