| 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
