Dev wrote:
> Hello all,
>
> I am trying to get a total number of rows returned form a query.
>
> SELECT count(this) from table group by this
>
> Currently it is returning x rows with a count of each of the group by.
>
> I need the count of the rows returned!
>
SELECT COUNT(DISTINCT this) FROM table
Andre
