Let's say I have a table with the field 'Track'. There are many duplicates of this field (for example, there are 12 entries of 'Hart High', 8 entries of 'Saugus High', etc.), but I only want to select one of each; a "unique selection" if you will.
The above will return all the results. How do I make a select statement to return one of each unique 'Track' (and eventually dump them into an array or variables)?Code:
SELECT * FROM table