Selecting qith no Duplicates

oscarooko

Registered User.
Local time
Today, 02:49
Joined
Oct 18, 2005
Messages
18
Hey, I have a table with columns A,B and C.
Column A may has a value that may be duplicated. eg

A B c
1
2
3
1
5
8
7
5
4
5
6
8

I need a querry that will only return the 8 unique numbers, instead of 12, which is infact the total number of entries!
 
If you select distinct table.columna,table.columnb,table.columnc from table)
 
Resolved

Thanks Smart!
 

Users who are viewing this thread

Back
Top Bottom