Re: Witango-Talk: I need to mangle the <@DISTINCT> tag

[Len Wright]

Using a sql query that does a "group by color" and a max on the number
field should do it shouldn't it?



Regards,

Len Wright
Plus International Corp
www.plusinternational.com

Direct: 604-415-2384
Fax:604-415-0830


>>> [EMAIL PROTECTED] 05/21/02 10:02PM >>>


I need to build an array and get the <@DISTINCT> rows but I only want
the
rows with the highest number in one of the columns.

so if I have

blue   5 
red   1
red   2
blue   1
blue   3
red   4


I only want 
red 4 and blue 5.

Is there a way to get the <@DISTINCT> tag to do this or do I have to
sift
through it manually?

Any tips/info are appreciated.

Thanks,


Michael Heth
Web Information Architect


__________________S E R V E R S M I T H S__________________

                           http://www.serversmiths.com/ 

                        Technology Infrastructure Provider
  
                   I N T E R N E T  P R E S E N C E  S O L U T I O N S

                    | EWordSmith | LightningSite | Enigma.Engine |

      ________M A R I N  C O U N T Y  C A L I F O R N I A________

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to
[EMAIL PROTECTED] 
                with unsubscribe witango-talk in the message body

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body