User:Ashishmanatkar

Welcome to my page..!!

--Queries to get name whose contact no having more than 1 (select Name,COUNT(*) as cnt from test1 group by Name having COUNT(*)>1) select test1.Name, count(*) from test1 inner join testcontact on test1.id = testcontact.id group by test1.Name having COUNT(*)>2