Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Suresh Maganti Eliminating Duplicate Rows using The PARTITION BY clause RE: Eliminating Duplicate Rows using The PARTITION BY clause

  • March 2, 2012 at 12:17 am

    #1454035

    I agree with those suggesting using a CTE, as I did in my old blog post: How do I remove duplicate tuples from a relation without any candidate keys?

    Now, it is seldom a good idea not to have a table without any candidate keys 🙂


    Ole Kristian VelstadbrĂĄten BangĂĄs - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]