Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!hplabs!hpl-opus!hpcc05!hpcc01!hansene
From: hansene@hpcc01.HP.COM (Ed Hansen)
Newsgroups: comp.databases
Subject: Re: SQL to select unique row on given fields
Message-ID: <770005@hpcc01.HP.COM>
Date: 6 May 91 17:09:54 GMT
References: <1991May01.003216.5146@hpmcaa.mcm.hp.com>
Organization: HP Corp Computing & Services
Lines: 7

The following query will retrieve all the distinct combination
of f1 , f2, f3 that occur in table T:

	SELECT DISTINCT f1 , f2, f3
	FROM T

JeanMarie