Re: remove dups

Posted in 2000

pauleccleston@my-deja.com — Mon, 26 Jun 2000 19:12:11 GMT — source: Informix-list mailing list archive (1991-1998)

SELECT id, min(text) from table group by id In article <8j2i1f$ln6$1@news.xmission.com>, Milos Prudek <prudek@nembv.cz> wrote: > > I have a table like: > > id text > 1 aaa > 1 aab > 1 aac > 2 bbb > 2 bbc > > I need to keep only the first record of each id, so that the result is > like > > id text > 1 aaa > 2 bbb > > When I try to use SELECT FIRST 1... I always get Unknown error 944. I'm > using IDS (informix dynamic server) 7.31 UC7. > > -- > Milos Prudek > Sent via Deja.com http://www.deja.com/ Before you buy.