SQL how to select n row from each interval of one column

For example, the table looks like

a	b	c
1	1	1
2	1	1
3	1	1
4	1	1
5	1	1
6	1	1
7	1	1
8	1	1
9	1	1
10	1	1
11	1	1

I want to randomly pick 2 rows from every interval based on column a, where a ~ [0, 2], a ~ [4, 6], a ~ [9-20].

Another more complicated case would be select n rows from every interval based on multiple columns, for example in this case the interval will be a ~ [0, 2], a ~ [4, 6], b ~ [7, 9], ...

Is there a way to do so with just SQL?

https://stackoverflow.com/questions/65744955/sql-how-to-select-n-row-from-each-interval-of-one-column January 16, 2021 at 07:43AM