On Tue, 21 May 2002 22:02:13 -0700, ServerSmiths Tango Development
wrote:
>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.
Is the array coming from a query? In SQL you could do:
SELECT colorcolumn, numbercolumn
FROM tablename t1
where numbercolumn =
(SELECT MAX (numbercolumn) FROM sametablename t2
WHERE (t2.colorcolumn = t1.colorcolumn))
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
