problem with select distinct (mssql)

[Snyders]

I try to do a distinct select from the Database (mssql):

select distinct Name from Table

but this does not work. It returns an empty table... It does work without the distinct. Anybody has any idea what is wrong??
Thanks in advance
seb

[[deleted]]

ues "group by" instead of "distinct"
select Name from Table group by name
because if there are many fields,"group by" does faster than "dinstinct",the more the faster.

but I don't know why your "distinct" dosen't work.:-(

yours
shakespeare

[Snyders]

I figured it out. I used order by in the end, and that does not work. Thank you anyways!

goethe

[[deleted]]

I use "group by" and "order by",and everything goes well.
I don't know why,sorry
:-(

yours
shakespeare