SELECT COUNT(*) FROM (SELECT * FROM tabella GROUP BY campo1, campo2)

Senza subquery CREDO non si riesca