Top 10 per group

[alucarddjin]

Is there a way to get the top 10 count for a number of groupings eg:

Col1    Col2    Count
G1        SG1     10
G1        SG2     8
G1        SG3     6
G2        SG4     21
G2        SG5     5
G2        SG6     1

So I have the top 10 for G1 then the top 10 for G2

[woodcock · Accepted solution]

Just do this:

... | sort 0 - Count
| dedup 10 Col1