Hi,

I have the same problem but I think that if you used select distinct and you had 2 duplicates it would return the first one only. The query below wouldn't return either of them. Is there a way of getting round this?


SELECT Track, COUNT(*)
FROM tbl1953
GROUP BY Track
HAVING COUNT(*) = 1;

PresumingEd: I'm not sure I understand your problem.

" have the same problem but I think that if you used select distinct and you had 2 duplicates it would return the first one only. The query below wouldn't return either of them. Is there a way of getting round this?


SELECT Track, COUNT(*)
FROM tbl1953
GROUP BY Track
HAVING COUNT(*) = 1;
"

If all you want is the number of unique records just do this:


SELECT Track
FROM tbl1953
GROUP BY Track

If you have a table called vendor2 and you want distinct records based on a field (tin in this case) and then for the query to grab all the other fields use the following sql as a guide. The table must have a primary key (pk in this case). You can also use min on the primary key field.


SELECT vendor2.*
FROM vendor2, (SELECT tin, max(pk) as pk2 FROM vendor2 GROUP BY tin) AS pull
WHERE vendor2.pk=pull.pk2;