Unique items

[Geoff Jones]

Hiya

I have a datatable with some columns. I would like to be able to retrieve a
list of the items in a column but only once e.g. if the column held
A,A,B,C,D,E,D then I'd like to be able to retrieve A,B,C,D,E.

Can anybody suggest how this can be done?

Thanks in advance

Geoff

[Qwert]

You mean with a SQL statement? 'Distinct' keyword after SELECT.

SELECT DISTINCT "column_name"
FROM "table_name"
"Geoff Jones" <no********@email.com> schreef in bericht
news:41*********************@news.dial.pipex.com.. .

Hiya

I have a datatable with some columns. I would like to be able to retrieve
a list of the items in a column but only once e.g. if the column held
A,A,B,C,D,E,D then I'd like to be able to retrieve A,B,C,D,E.

Can anybody suggest how this can be done?

Thanks in advance

Geoff

[Phill. W]

"Geoff Jones" <no********@email.com> wrote in message
news:41*********************@news.dial.pipex.com.. .

I have a datatable with some columns. I would like to be able to
retrieve a list of the items in a column but only once e.g. if the
column held A,A,B,C,D,E,D then I'd like to be able to retrieve

A,B,C,D,E.

OK; got a little confused by the "sideways" representation of columns
for a second, there, but I think what you're looking for is the "distinct"
keyword, as in

select distinct ColumnName
from TableName
where Thingy = Whatsit
or Whatever

Simply enough if you only want a /single/ column; things get a little
hairier if you're retrieving /more/ than one.

HTH,
Phill W.

[Ritesh Jain via DotNetMonster.com]

Hi,
Use SELECT Distinct ColumnName FROM Table
Hope this will help u........

Regards,
Ritesh

--
Message posted via http://www.dotnetmonster.com

[Geoff Jones]

Many thanks everyone

Geoff

"Ritesh Jain via DotNetMonster.com" <fo***@DotNetMonster.com> wrote in
message news:e3******************************@DotNetMonste r.com...

Hi,
Use SELECT Distinct ColumnName FROM Table
Hope this will help u........

Regards,
Ritesh

--
Message posted via http://www.dotnetmonster.com