> 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