Try this Will work for Sql Server(Any version), MySql,Oracle, MSAccess
select * from myTable where customername in (
select customername
from myTable
group by customername,phonenum,city,street
having(count(customername)>1 and count(phonenum)>1 and count(city)>1 and count(street)>1))
Output:
id customername phonenum city street
19 jon 555 NK st.5
37 jon 555 NK st.5
Hope this helps :)
Niladri Biswas
