create table kullanicilar(username varchar, ipadress int);
insert into kullanicilar values("Ali", 25);
insert into kullanicilar values("Ahmet", 20);
insert into kullanicilar values("Mehmet", 25);
insert into kullanicilar values("Ali", 12);
insert into kullanicilar values("Ersoy", 20);
select t1.username,t1.ipadress
from kullanicilar t1 inner join kullanicilar t2 on t1.username = t2.username
where t1.ipadress <> t2.ipadress;Aşağıdaki sitede sql'i test edebilirsin. https://www.jdoodle.com/execute-sql-online/