RE: MySQL GROUP BY Anomaly?

Perhaps the time component of the date is different, hence you are getting back what looks like duplicate rows but they're not really? - Max Martin Anderson QA Engineer ProfitLogic Eleven Cambridge Center Cambridge, MA 02142 t: 617.218.1946 -Original Message- From: Jay Blanchard

RE: MySQL GROUP BY Anomaly?

[snip] Perhaps the time component of the date is different, hence you are getting back what looks like duplicate rows but they're not really? [/snip] The time components are all the same. And if I say this in my query; WHERE RecordDate = '2002-03-04' , it works (returns one row of data) or if

RE: MySQL GROUP BY Anomaly?

[mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 1:23 PM To: [EMAIL PROTECTED] Subject: RE: MySQL GROUP BY Anomaly? [snip] Perhaps the time component of the date is different, hence you are getting back what looks like duplicate rows but they're not really? [/snip] The time components are all

RE: MySQL GROUP BY Anomaly? SOLVED

[snip] I have 2 tables with RecordDate in them, one has millions of records, one has hundreds of records. If I perform the following query on the table with hundreds; mysql select RecordDate - from tblInfo - WHERE RecordDate BETWEEN '2002-03-04' AND '2002-03-06' - GROUP BY