Re: query help

Posted in 2000

Obnoxio The Clown — Thu, 20 Apr 2000 11:56:12 BST — source: Informix-list mailing list archive (1991-1998)

From: Jason <jasong@paradise.net.nz> > >how can I return all occurrences of rows that occur more than once in a >table if they have the same values in 3 columns??? > >example, > >row 1 and 3 match in columns 2,3 and 4 > >aaa|bbb|ccc|ddd|eee <-return this >bbb|eee|fff|ggg|hhh >fff|bbb|ccc|ddd|jjj <-return this also Normalise your database? :0) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com