var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: modifying a select to return row count
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.