remove repetitive queries

[ayushchd]

I have in my databse suppose :

1. a
2. a
3. b
4. b
5. c
6. c

Can I execute a query that will return only a, b and c and not a, a, b , b, c, c

[jatar_k]

SELECT DISTINCT columnname FROM tablename

[ayushchd]

Thanks, it worked.