Selecting qith no Duplicates (1 Viewer)

oscarooko

Registered User.
Local time
Today, 12:31
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!
 

Smart

Registered User.
Local time
Today, 17:31
Joined
Jun 6, 2005
Messages
436
If you select distinct table.columna,table.columnb,table.columnc from table)
 

oscarooko

Registered User.
Local time
Today, 12:31
Joined
Oct 18, 2005
Messages
18
Resolved

Thanks Smart!
 

Users who are viewing this thread

Top Bottom