Find multiple programs with same SSNs

Asked Oct 04 '22 at 16:45

Active Oct 04 '22 at 17:12

Viewed 39 times

I have the following tables:

----- Programs with same SSN

select MAX(p.name)
from raw_prod.bedrock.contact c
join raw_prod.bedrock.program_c p on p.account_id_c = c.account_id
HAVING COUNT(*) > 1;

Desired output: Different program names with same SSNs

Program Name ---------- SSN

P - 0001 --------- 000-00-0000

P - 0002 -------- 000-00-0000

P - 0003 --------- 111-11-1111

P - 0004 ---------- 111-11-1111

P - 0005 ----------- 111-11-1111

P - 0006 ----------- 222-22-2222

P - 0007 ------------ 222-22-2222

Sorry about the formatting issues.

The query should give me P- 0001 and P- 0002 as these programs have same SSNs

Please let me know if more info is needed. I am new to SQL :(

edited Oct 04 '22 at 17:12

asked Oct 04 '22 at 16:45

user18421794

You are missing `GROUP BY` and the purpose of your `MAX()` is not clear. – PM 77-1 Oct 04 '22 at 16:50
Please [edit] your question to include some ***sample*** data and the desired result. – PM 77-1 Oct 04 '22 at 16:51
Does this answer your question? [Finding duplicate values in a SQL table](https://stackoverflow.com/questions/2594829/finding-duplicate-values-in-a-sql-table) – PM 77-1 Oct 04 '22 at 16:51
I changed the title. Please help. – user18421794 Oct 04 '22 at 17:13
As I already pointed out - add `GROUP BY SSN` – PM 77-1 Oct 04 '22 at 17:16

0 Answers0