Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test_tbl (id serial,create_date timestamptz,display_name text,address text);

insert into test_tbl(create_date,display_name,address)
values (NOW(),'name1', 'addr1'),(NOW(),'name1', 'addr1'),(NOW(),'name1', 'addr1'),
(NOW(),'name2', 'addr2'),(NOW(),'name2', 'addr2'),(NOW(),'name3', 'addr2'),
(NOW(),'name3', 'addr3'),(NOW(),'name4', 'addr3'),(NOW(),'name1', 'addr3'),
(NOW(),'name5', 'addr5');
10 rows affected

select *
from test_tbl


id
create_date
display_name
address


1
2020-12-01 18:43:07.848046+00
name1
addr1

2
2020-12-01 18:43:07.848046+00
name1
addr1

3
2020-12-01 18:43:07.848046+00
name1
addr1

4
2020-12-01 18:43:07.848046+00
name2
addr2

5
2020-12-01 18:43:07.848046+00
name2
addr2

6
2020-12-01 18:43:07.848046+00
name3
addr2

7
2020-12-01 18:43:07.848046+00
name3
addr3

8
2020-12-01 18:43:07.848046+00
name4
addr3

9
2020-12-01 18:43:07.848046+00
name1
addr3

10
2020-12-01 18:43:07.848046+00
name5
addr5


select * from test_tbl
where address in (
select address
from test_tbl
group by address
having count(distinct display_name)  > 1)


id
create_date
display_name
address


4
2020-12-01 18:43:07.848046+00
name2
addr2

5
2020-12-01 18:43:07.848046+00
name2
addr2

6
2020-12-01 18:43:07.848046+00
name3
addr2

7
2020-12-01 18:43:07.848046+00
name3
addr3

8
2020-12-01 18:43:07.848046+00
name4
addr3

9
2020-12-01 18:43:07.848046+00
name1
addr3

id	create_date	display_name	address
1	2020-12-01 18:43:07.848046+00	name1	addr1
2	2020-12-01 18:43:07.848046+00	name1	addr1
3	2020-12-01 18:43:07.848046+00	name1	addr1
4	2020-12-01 18:43:07.848046+00	name2	addr2
5	2020-12-01 18:43:07.848046+00	name2	addr2
6	2020-12-01 18:43:07.848046+00	name3	addr2
7	2020-12-01 18:43:07.848046+00	name3	addr3
8	2020-12-01 18:43:07.848046+00	name4	addr3
9	2020-12-01 18:43:07.848046+00	name1	addr3
10	2020-12-01 18:43:07.848046+00	name5	addr5