S
Saeed
been a while doing SQL programming , its all wiped.
If i have a table with a field say refNo
1001
1002
1003
1001
How woud I be able to get a query telling me the distinc RefNo's with
the number of occurance (duplicates in the table for each RefNo)
Something like
1001 2
1002 1
1003 1
Cheers
If i have a table with a field say refNo
1001
1002
1003
1001
How woud I be able to get a query telling me the distinc RefNo's with
the number of occurance (duplicates in the table for each RefNo)
Something like
1001 2
1002 1
1003 1
Cheers