Re: How do i get partial DISTINCT's

Posted in 1996

Atul Patankar — Thu, 11 Jan 1996 01:59:29 GMT — source: Informix-list mailing list archive (1991-1998)

:crp: wrote: > > I have one table with 5 columns, John - George - Paul - Ringo - Beatle. > The data within needs to transferred over to another table, TabB. > TabB has a unique index based on John-George combo. > > Using "Select distinct (John,George), Paul, Ringo,Beatle" doesn't work > as distinct applies to all the columns, which i don't want. Just the > rows with distinct John,George. The "distinct" gets applied to all columns to remove ambiguity. If you had the following two rows in Table A, which one would you select for inserting into TabB? You will have to come up with a querry based on that. John1 George1 Paul1 Ringo1 Beatle1 John1 George1 Paul2 Ringo2 Beatle2 HTH -Atul.