A common Sql problem is getting the first record of each set of records with a duplicate value in a column.

For example, suppose you have a set of orders with email addresses. You want to email each person, but you do not want to send them multiple emails.

Here is some Sql you can use to solve the problem.

select email, min(idorder) as idorder
from orders
group by email