Re: Order By When Grouping

2004-12-19 Thread Rhino
- Original Message - From: "Jalil Feghhi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, December 19, 2004 3:37 PM Subject: Order By When Grouping > Let's say I have a table w/ three rows: ID, Time, and Name. when I do: > First of all, I thin

Order By When Grouping

2004-12-19 Thread Jalil Feghhi
Let's say I have a table w/ three rows: ID, Time, and Name. when I do: select Time, Name group by Name Order By Time MySQL selects one of the Time fields if there are rows with the same Name and then does the ordering using this selected field (I am not sure what is the logic but it seems it is