Is there a query that will let me display one instance of all the unique occurrences that appear in a column?
E.g. I have a table called products which contains the fields:
NSN
Contract Number
Description
Quantity
Is there a query that will give me a list of all the Contract Numbers that are in that table, but only one of each.
i.e. there might be 101 items with a contract number of 111, and 50 with 222 and 200 with 333.
But I would just want the results to be
111
222
333
Simply a list of all available contracts within that table.
I'm sure I've seen the code for this before but can't remember where I read it.
