Showing posts with label Duplicate Value Findout(Sql server). Show all posts
Showing posts with label Duplicate Value Findout(Sql server). Show all posts
Saturday, March 13, 2010
Duplicate Value Findout(Sql server)
Select count(*) ,firstname,lastname,depart from emp group by firstname,lastname,depart having count(*)>1
Subscribe to:
Posts (Atom)