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.
Example:
list of all last order dates for a customer
0
votes
Crystal
shared this idea
1 comment
-
Klaus Oberdalhoff commented
You Already CAN do that - just use SELECT TOP 1 * FROM whatever WHERE ....