can I remove any duplicates from my query result?

Question

can I remove any duplicates from my query result
so if the query result is
123
123
123
456
456
456
789
789
789
I want my result to be
123
456
789

Answer 1

trying adding a distinct clause. Select (distinct) from... what's your query.

Answer 2

There is a KEYWORD from the standard SQL 03 standard and I believe before which is called DISTINCT.

If the result set contains the same row, then DISTINCT will filter them off.

Forexample in your query I am doing something similar.
SELECT numfield FROM numtable WHERE category=3
^ That might give you what you have above. Note I am just doing it , your schema representation wont be the same.

Now if I do this... SELECT DISTINCT numfield FROM numtable WHERE category=3
You will get those..
123
456
789

Remember and NOTE that You can have DISTINCT as in groups. So if you want to find the duplicates of 2 fields you could do DISTINCT(x,y).

Goodluck