How to get unique record

[subbu]

Hi,
I have three fields in a table.Field A, B,C.For each A
there may be more than one B or one C.I want to extract
unique A only.How to go about??

Any help in this regard is highly appreciated

subbu

 

[May]

under Query SQL, key in
Select distinct A from tablename

May