Distinct Fieldname in SQL 2000

Ashish
Posted by Ashish under Sql Server category on | Views : 1993
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

Comments or Responses

Login to post response