Powered By Blogger

Wednesday 15 June 2016

How to find duplicate records if one of the column has unique value.



SELECT Count(*)
FROM   (
        SELECT DISTINCT
               Col1
             , Col2
             , Col3
        FROM   table_name
       ) As AAA

No comments: