select year, make, model, color, unit, count(*) from property group by year, make, model, color, unit having count(*) > 1;

The above query is useful to identify similar records inside of a single table, but I would sometimes only like to know the number of rows that would be returned as if I ran the query without a limit.

Any help much appreciated.