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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to