[thelist] SQL to return one result for duplicate values

Erik Mattheis gozz at gozz.com
Mon Apr 29 20:55:00 CDT 2002


At 9:21 PM -0400 4/29/02, rudy wrote:
>    select word_id, word_value, word_type, word_date
>      from thetable XX
>    where word_id =
>          ( select min(word_id)
>                from thetable
>             where word_value = XX.word_value )

Yes, something like that was the solution (I think you meant where
word_id IN instead of where word_id =).

Please note the double entendre emoticon.
--

__________________________________________
- Erik Mattheis

(612) 377 2272
http://goZz.com/

__________________________________________



More information about the thelist mailing list