New posts in limit-per-group

How to select the first N rows of each group?

sql sqlite greatest-n-per-group limit-per-group