Everyone, Have u encountered this kind of query?
mysql> select edate from traffic where year(edate)='2001' group by month(edate); +------------+ | edate | +------------+ | 2001-04-29 | | 2001-05-01 | | 2001-06-01 | | 2001-07-01 | | 2001-08-01 | | 2001-09-01 | | 2001-10-30 | | 2001-11-01 | | 2001-12-01 | +------------+ 9 rows in set (10 min 53.83 sec) mysql> select count(*) from traffic; +----------+ | count(*) | +----------+ | 2645563 | +----------+ 1 row in set (0.00 sec) mysql> is there a problem with my select statement?... R.B.Roa Traffic Management Engineer PhilCom Corporation Tel.No. (088) 858-1028 Mobile No. (0919) 30856267 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php