coutning the nu,ber of repeates

[pelegk2]

how can i check in a certain col
the number of repeates of each of the values?
for example if this is my table :
1
2
5
6
8
3
2
6
9

1 - reapets once
2 - repeats twice and so on...
how do ido this?
thnaks in advance
peleg

[bubblenut]

SELECT col, count(*) FROM table GROUP BY col

This will give you the column value in the first field and the number of elements found with that value in the second field.

HTH
Bubble