Unique Records

[sweed]

In sybase, what is the SELECT statement to select the unique values of a table. Let's say I have the following sequence in my table:
A
A
A
B
C
B
C
B
B
A

...and I want to just see what unique values are in that table: A,B,and C. What is the select statement in Sybase to do this, I know the one in Oracle, but it does not work in Sybase. Any help would be nice.

 

[Guest_imported]

select distinct
column1
from table


This is identical to Oracle, so either I do not understand the question, or something else is missing in the explanation.

jlipman@netzero.net