SQL statement to select only one name from a lot of same names

[sivadhanekula]

Hi every one....

I have SQL statement like "Select Fullnmae from abssubtest" and if I do so the output is the list of all data containing in the Fullname...incl uding the data with same names is repeating...I dont want the repeated data...i.e. if the Fullname data has
1. Ulm
2. Prague
3. Frankfurt
4.Prague
5. Frankfurt I want the output as only
1.Ulm
2.Prague
3.Frankfurt
but not the repeated city names...

can anyone please help me in this...as soon as possible

Regards
Siva

[mwasif]

Use DISTINCT
[code=mysql]Select DISTINCT Fullnmae from abssubtest[/code]

[sivadhanekula]

Thank you...it works