Reducing like returned data

[Subsonic]

I am working on a personal project and am drawing a complete blank
(too much celebrating last night?) on the SQL term that is used to
eliminate multiples of like data when it is returned from the
database.

ie, instead of ....
red
blue
red
green

it would return ...
red
blue
green

Sorry for the trouble and thanks.

[David Portas]

DISTINCT or GROUP BY will do that for you.

Example:

SELECT DISTINCT colour
FROM ColourTable

--
David Portas
------------
Please reply only to the newsgroup
--

[Subsonic]

Thanks, David!

On Thu, 1 Jan 2004 23:47:08 -0000, "David Portas"
<RE****************************@acm.org> wrote:

DISTINCT or GROUP BY will do that for you.

Example:

SELECT DISTINCT colour
FROM ColourTable

--
David Portas
------------
Please reply only to the newsgroup