I have a table that contains duplicate values. I want to count one instance of each. For example, the table pend_list has claim_no field with data:
claim_no
2215176239
2215176239
2215176240
2215176241
2215176245
2215176247
2215176247
The count of the claim_no should be 5 but I keep on getting 7 since it is counting the dup claim_no. How can I change this query to count appropriately?
SELECT DISTINCTROW Count(pend_list.CLAIM_NO) AS ClaimCount
FROM pend_list;
Thanks.
claim_no
2215176239
2215176239
2215176240
2215176241
2215176245
2215176247
2215176247
The count of the claim_no should be 5 but I keep on getting 7 since it is counting the dup claim_no. How can I change this query to count appropriately?
SELECT DISTINCTROW Count(pend_list.CLAIM_NO) AS ClaimCount
FROM pend_list;
Thanks.