select from table with unique values

Started by ivanabout 22 years ago2 messages
#1ivan
iv@psycho.pl

hi

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

#2Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: ivan (#1)
Re: 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