Thread: select from table with unique values

select from table with unique values

From

ivan

Date:

28 December 2003, 20:43:23


hi

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

Re: select from table with unique values

From

Christopher Kings-Lynne

Date:

28 December 2003, 23:45:17

> 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