[Solved] A query which removes duplicates

[beejayzed]

Hi
I want to be able to enter values in a table, then have a query (or queries that work together) to do the following:
1. Remove the duplicates from the table.
2. Display how many values there are of each value.

e.g for 1,5,6,2,8,6,1,2
1:2 5:1 6:2 2:2 8:1

Any tips for doing this?
Thanks in advance.

[Villeroy]

Code: Select all

SELECT "Value", COUNT("Value") AS "How Many" FROM "Table" GROUP BY "Value" ORDER BY "How Many"

If you add more fields, mind that every field needs to be grouped or aggregated by a one of SUM, COUNT, AVGERAGE, MIN, MAX. Every value in the result set represents one or more values in the original table.

[beejayzed]

Thanks very much for the help.