A place to learn from Little Techie...
Little Techie who is Microsoft Most Valuable Professional (MVP), Most Valuable Contributor (MVC), Most Valuable Member (MVM), Member of the Year..........
Pages
▼
Sunday, February 17, 2008
Duplicate Records
I was looking at the forums and my mail box, the big question that every bods asks me is how to find out the duplicate records.
this is the answer for this query.
SELECT FROM tablename GROUP BY HAVING count(*) > 1
Simple query..can u tell me what is the equivalnet of ROWid in SQL Server
ReplyDelete