Selecting once where there are many

onlyu2 · March 24th, 2004, 08:12 PM

Hello,

I've seen the answer to this somewhere but have searched my head off. If I am selecting entries from a table, but there are multiple occurances of the same entry (such as "apple" being stored 5 times in a table), how do I select the repetitive entries only once?

Such as:
"select name from table where id = 1" results in:
"Apple, apple, apple, pear, grape, apple"
When what I want is:
"Apple, pear, grape"

Hope that's clear, and thank you!

CFerthorney · March 25th, 2004, 06:22 AM

Let me get this right, you are after only ONE occurence of apple, ONE occurrence of pear, etc?

If that is the case use the DISTINCT key word

Code:

SELECT DISTINCT name FROM table WHERE id =1;

hth

---
David Thorne, Student
UK