DISTINCT selects values which are different in all columns, not just the first. So if your data is:
id Name x y
1 Joe 1 2
2 Joe 1 3
3 Joe 1 3
Then
SELECT DISTINCT [Name], x, y FROM MyTable
Will return:
Joe 1 2
Joe 1 3
If you want to only return one row with "Joe" in, then you need to think more carefully and decide which of the rows that will be otherwise identical you are interested in!
SQL can't do that - it doesn't know which of the three "Joe" rows you do want.