[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