having the possibility to restrict a query result to a sample of rows.

For example my query gives me 10000 people and I just need to send 1000 emails (because of my number of coupons or for winners of a game).

It could be great if I can restrict the number of rows of my queries.