Sort by number of rows

[k209310]

This is hard to explain so ill try my best. I hope it makes some sense

Is it possible to sort my data depending upon the number of entries in a table.

For example i would like to sort the data below depening upon the number of entries in field one i would to display data Where Field = 20 and 3 rows or where field = 20 and two rows.

number Field
1 20
2 20
3 20
4 10
5 10
6 20
7 20



Please get bakc to me if this odesnt make any sense.