"SELECT DISTINCT COUNT(*) FROM Tmp" e identic cu "SELECT COUNT(*) FROM Tmp"

Probabil vrei să scrii "SELECT COUNT(DISTINCT coloana) FROM Tabela"
sau "SELECT COUNT(*) FROM (SELECT DISTINCT * FROM Tmp) x".

Răzvan