hi

im having trouble getting a query done
suppose the table is called t and may contain duplicate records,
i.e. records, where ALL fields are equal
what i want the query to return is a list of all the fields in a
duplicate record plus the count of occurences.
so if table t is:

a b c d
3 5 7 9
3 5 4 2
3 5 7 9
1 4 7 6
3 5 7 9
3 5 4 2

the query should return:

a b c d count
3 5 7 9 3
3 5 4 2 2

does anyone have an idea?

thanks

martin