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