

hi

how to do select from same table to get only unique values from same
column(s) ?



Sun, 28 Dec 2003 22:44:16 +0100 (CET)
ivan <iv@psycho.pl>
select from table with unique values
> how to do select from same table to get only unique values from same
> column(s) ?

SELECT DISTINCT a, b FROM tab;

or even:

SELECT DISTINCT ON (a) a, b FROM tab;

Chris

Mon, 29 Dec 2003 08:44:17 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: select from table with unique values