This Query gives Distinct Fieldname in SQL 2000.
SQL QUERY SYNTAX:
Select Distinct Fieldname from tablename group by Fieldname having count (Fieldname)>1 order by Fieldname
SQL QUERY:
Select Distinct employeename from employee group by employeename having count (employeename)>1 order by employeename