lundi 1 février 2016

Find the number of duplicates in a row using sqlite

I have a database table which has entries with 8 numbers associated with each of the entry name . So i need to write a Query to get the total number of contact names which has duplicate numbers associated with each of the contact name. I have a sqlite table as shown below schematics

Name |Num0 |Num1 |Num2 |Num3|Num4 |Num5 |Num6 |Num7

Assume that i have 6000 entries and there are 100 entries which has duplicate numbers which can fall in any of the columns starting from TelNum0 to TelNum8.

For eg: as shown below i have a Database which has 5 entries total having 5 names like: Name Num0 Num1 Num2 Num3 Num4 Num5 Num6 Num7
1)John 1234 1234 1234

2)Hebbar 234

3)Jim 9876 9876 9876

4)Kim 111 111 111

5)Kate 666

Now when i run a query, i should get the number of results as 3 since John, Jim and Kim had duplicate entries associated with them .

Thanks a lot in advance

Aucun commentaire:

Enregistrer un commentaire