[UPHPU] specifying with row is displayed when using MySQL GROUP BY

David Boucha boucha at gmail.com
Wed Jan 14 19:05:25 MST 2009


Wade,

You tell DISTINCT which columns you want it to look at. So you can ignore
the columns that you don't care about.

Sorry for the top post. I sent this from my phone.

Dave

On Jan 14, 2009 6:37 PM, "Wade Preston Shearer" <wadeshearer.lists at me.com>
wrote:

On 14 Jan 2009, at 17:08, Brandon Stout wrote: > Have you tried SELECT
DISTINCT instead of GROUP BY...
According to my understanding, DISTINCT eliminates duplicate rows and in my
case my rows are similar but not unique (one column is different), DISTINCT
will not help.



_______________________________________________

UPHPU mailing list
UPHPU at uphpu.org
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net


More information about the UPHPU mailing list