SQL Command

[Beany]

Hi,

i have a combobox that shows a list of providers...... .........

in this list there are duplicates... for example

1.BT
2.CABLE
3.BT
4.BT

so there are three BT's.......

is there an SQL statement that i can use that will only show BT once?
anyone know this SQL?

[ronverdonk]

You can establish that by using the GROUP BY attribute, as in
[php]SELECT provider FROM table_name ORDER BY provider GROUP BY provider[/php]
(ORDER BY sorts the list of providers)

Ronald :cool:

[prileep]

SELECT distinct provider FROM table_name

[ronverdonk]

SELECT distinct provider FROM table_name

You are right of course! What was I thinking?

Ronald :cool: