[mulmen]

In SQL we do that with a RANK window function then apply a filter to that rank. It can also be done with a correlated subquery.