In fact I couldn't suppress the LIMIT as it would return a lot of rows ;) However the order by doesn't seem to have any effect.
----- Original Message ----- From: "DL Neil" <[EMAIL PROTECTED]> To: "Carsten Gehling" <[EMAIL PROTECTED]>; "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, April 14, 2002 7:52 PM Subject: Re: How does DISTINCT really work ? > Well done Carsten! > Which may bring us back to the relationships between the data/columns > being used to control the query. > Jocelyn: Did you try out my previous suggestions? > Please advise, > =dn > > ----- Original Message ----- > From: "Carsten Gehling" <[EMAIL PROTECTED]> > To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>; "DL Neil" > <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: 14 April 2002 18:46 > Subject: SV: How does DISTINCT really work ? > > > > > Fra: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]] > > > Sendt: 14. april 2002 19:22 > > > > > In fact what it's odd is when I use EXPLAIN, I don't see anywhere > DISTINCT > > > in the EXPLAIN result : > > > > That's because the MySQL optimizer converts your distinct into a group > by. > > Read more here: > > > > http://www.mysql.com/doc/D/I/DISTINCT_optimisation.html > > > > - Carsten > > > > > > > > --------------------------------------------------------------------- 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
