Just get the first record for each whatever in a list
In queries, when there are multiple records for criteria, it would be nice if we could specify to just get the first record matching a certain condition but show all records matching criteria for the query.
list of all last order dates for a customer
Klaus Oberdalhoff commented
You Already CAN do that - just use SELECT TOP 1 * FROM whatever WHERE ....