March 23rd, 2003, 05:29 PM
returning a list of unique names
Hi everybody ,
I've just started with Postgres ( and databases in general ) about a week or so ago , so I'm sorry if my question might make me look like ... i'm new
I have read a book on it and searched through a few sites , and there is one feature which I could not find .
I was wondering if such a feature exists or there is a way of achieving this in postgres .
Basically I have a table that say will return 10 names . 4 of these names would be unique and some of them will be repeated more than once within this table ...
I'm searching for a way of listing only the unique names ...
Thanks in advance
March 23rd, 2003, 07:55 PM
SELECT DISTINCT name_column FROM name_table;
March 23rd, 2003, 10:18 PM
thank you , that's exactly what i needed ...