About Record Selection

[Sleidia]

Good morning,

It would be great if someone would have a solution to
the following problem:

When you have in one column:
A
C
C
C
B
B
D
A
...etc...

, how can you display the following?? :
A
B
C
D
...etc....

I hope this "simple" question won't bother anyone.
Thanks a lot.

 

[netcomander]

hi

assuming your column is named myColumn,
your select-statement should be:

SELECT DISTINCT myColumn FROM ...

that's it

greetings netcomander