Re: Sort and remove duplicates

On Sep 28, 10:33 am, gba...@xxxxxxxxxx (Greg Bacon) wrote:
In article <1190985054.159629.205...@xxxxxxxxxxxxxxxxxxxxxxxxxxx>,
JimJx <webmas...@xxxxxxxxxxxxxxxx> wrote:

: I have a db (MySQL) that I need to sort on the first field and
: remove dups from.
:
: For example, let's say I have Red,1,2,3,4,5 and Blue,1,2,3,4,5
: and Green,1,2,3,4,5 and Green,2,2,2,2,2
:
: How can I come out with Blue,1,2,3,4,5;Green,1,2,3,4,5;
: Red,1,2,3,4,5??

Why does the Green row get 1,2,3,4,5 on the output?

Greg
--
The list of stable paper currencies built by central bankers is as
short as the list of stable democracies built by armed invaders.
-- Bill Bonner

Because Green would be a dup and 1,2,3,4,5 comes before 2,2,3,4,5

.