Once only

wxdqz

New Member
Good Morning peeps!

Right say i've got a data base a abit like this.

Thing |Number

cake | 2
fish | 2
cake | 4
kelp | 4
cake | 1
fish | 2
lemon | 2
hand | 6

I want to do a select * from table

But only want the following results

thing |Number

cake | 2
fish | 2
kelp | 4
lemon | 2
hand | 6

No duplicates in the thing column.

Does anyone understand me???
 
Back
Top