On Thu, Jan 09, 2003 at 12:24:28PM -0600, Paul DuBois wrote:
...
You probably want SUM(col3 < col4,1,0) instead.
Hey Paul,
Am I missing something here?
I did not think that SUM(col3 < col4,1,0) would be valid syntax?
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | htt
At 10:29 -0600 1/9/03, Meena Vyavahare wrote:
Here is my query-
Select col1, col2, count(*) as total, count(col3 < col4) as violations
from table1
Where condn
group by col1, col2
The result of this query shows same values at both the columns for total
and violations.
The count(expr) does
On 9 Jan 2003, at 10:29, Meena Vyavahare wrote:
> Select col1, col2, count(*) as total, count(col3 < col4) as violations
> from table1
> Where condn
> group by col1, col2
>
> The result of this query shows same values at both the columns for total
> and violations.
&g
Here is my query-
Select col1, col2, count(*) as total, count(col3 < col4) as violations
from table1
Where condn
group by col1, col2
The result of this query shows same values at both the columns for total
and violations.
The count(expr) does not work
Thanks
Me