List:General Discussion« Previous MessageNext Message »
From:Richard Unger Date:September 17 2002 6:59pm
Subject:aggregate functions producing bad data
View as plain text  
My query:

SELECT 
	count(id), 
	count( IF(call_end - call_start > 5, id, NULL) ), 
	count( IF(call_end - call_start <= 5, id, NULL) )
FROM 
	t_calllog_calls;

My result:

1994
1956
35

However, 1956 + 35 != 1994.

Running MySQL 3.23.49-nt

Cheers,
Rich
Thread
aggregate functions producing bad dataRichard Unger17 Sep
  • Re: aggregate functions producing bad dataBrian Reichert17 Sep
    • Re: aggregate functions producing bad dataDan Nelson17 Sep
  • Re: aggregate functions producing bad dataGelu Gogancea17 Sep
  • Re: aggregate functions producing bad dataGelu Gogancea17 Sep
    • Re: aggregate functions producing bad datamtoth18 Sep
  • Re: aggregate functions producing bad dataGelu Gogancea17 Sep
RE: aggregate functions producing bad dataRichard Unger17 Sep
RE: aggregate functions producing bad dataRichard Unger17 Sep
  • RE: aggregate functions producing bad datamtoth17 Sep
RE: aggregate functions producing bad dataRichard Unger17 Sep
  • Re: aggregate functions producing bad dataJay17 Sep
    • re: Re: aggregate functions producing bad dataVictoria Reznichenko18 Sep
RE: aggregate functions producing bad dataRichard Unger17 Sep
RE: aggregate functions producing bad dataRichard Unger17 Sep
  • Re: aggregate functions producing bad dataBenjamin Pflugmann18 Sep
RE: aggregate functions producing bad dataGerben Gieling18 Sep