[snip]
Is there any way in SQL (and especially MySQL) that I can determine
the count of rows that would be returned by a SELECT with a GROUP BY
and a HAVING, without retrieving the rows?
For example, I want the number of orders whose total value is greater
that 1. The orders would be SELECTed
Is there any way in SQL (and especially MySQL) that I can determine
the count of rows that would be returned by a SELECT with a GROUP BY
and a HAVING, without retrieving the rows?
For example, I want the number of orders whose total value is greater
that 1. The orders would be SELECTed like t
