Atlantis67

• May 28th, 2015

 

Im sure there are several ways to do it.
Why not using a group by query ?
suppose you want to list duplicate names and phone numbers in a customer table :

Select
Name,
Phone,
Count(*) as Nb
From
Customer
Group By
Name,
Phone
Where
Nb>1

Ashwinee Kumar

• Jun 1st, 2015

 

Code
WITH T AS


(


SELECT RN=Row_Number() over(partition BY ColumnName1,.. ORDER BY ColumnName1,...) , * FROM TableName 


) SELECT * FROM T WHERE RN>1

ashbittu

 Profile Answers by ashbittu 

• Jun 1st, 2015

 

Code
WITH T AS


        (


                SELECT RN=ROW_NUMBER() Over(PARTITION BY Column1, ... ORDER BY Column1,...), 


                * FROM TableName


        )


                SELECT * FROM T WHERE RN>1 


 

Sharath

• Jun 8th, 2015

 

Select ename ,count(ename) from emp group by ename