On Fri, Oct 21, 2005 at 03:13:38PM +0800, Sherwin Daganato wrote:
> SELECT (SELECT SUM(f1)
> FROM (SELECT COUNT(*) AS f1
> FROM am
> GROUP BY hour(d_date2)) AS t1) =
> (SELECT SUM(f2)
> FROM (SELECT COUNT(*) AS f2 FROM am
> GROUP BY MONTH(d_date2)) AS t2)
> AND (SELECT SUM(f1)
> FROM (SELECT COUNT(*) AS f1
> FROM am
> GROUP BY hour(d_date2)) AS t1) =
> (SELECT COUNT(*)
> FROM am);
>
Copy-and-paste error! Instead, change that to
SELECT (SELECT SUM(f1)
FROM (SELECT COUNT(*) AS f1
FROM am
GROUP BY hour(t_time)) AS t1) =
(SELECT SUM(f2)
FROM (SELECT COUNT(*) AS f2
FROM am
GROUP BY MONTH(d_date2)) AS t2)
AND (SELECT SUM(f1)
FROM (SELECT COUNT(*) AS f1
FROM am
GROUP BY hour(t_time)) AS t1) =
(SELECT COUNT(*)
FROM am);
It should return the same result though.
HTH
--
$_=q:; # SHERWIN #
70;72;69;6e;74;20;
27;4a;75;73;74;20;
61;6e;6f;74;68;65;
72;20;50;65;72;6c;
20;6e;6f;76;69;63;
65;27;:;;s=~?(..);
?=pack q$C$,hex$1;
;;;=egg;;;;eval;;;
_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph
