distinct

[nagasea]

ID ORDER NAME
1 1000 john
2 1000 john
3 2000 brad
4 3000 greg
5 4000 tom
6 4000 tom

I want to get John, Brad, Greg and Tom
how to select that name i think distinct is what i need but i dont know how to use it

[vponz]

SELECT DISTINCT NAME FROM TABLE

[nagasea]

but actually i'm pulling that name because the order number is same. not looking the name row

[barand]

SELECT DISTINCT ORDER, NAME FROM TABLE

[nagasea]

that's works..
but how to select more than 2 fields ?

looks like this is not working :
SELECT DISTINCT order_id,order_from,date_unix