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
 

ashbittu

 Profile Answers by ashbittu 

• Jun 1st, 2015

 

Code
 

Sharath

• Jun 8th, 2015

 

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