Comparing Two Result in Postgres

Question

I got a problem in comparing two set result in Postgres.

I have two table (consider both of them have primary key attribute), first is a CarWithOwner table that have two attribute CarName and Owner. The Second table is CarList with one attribute Name.

From those table I want to get the owner's name that has all the cars from the CarList table.

My first method is to grouping the person with the car then compare it with the carlist. Like this :

SELECT owner 
from CarWithOwner 
GROUP BY carname, owner 
HAVING carname = ALL(SELECT name from CarList);

But it doesn't give me the right result. Can you please give me a solution?

Don't edit your question if your question is solved. If you want to mark the question as "Solved", accept the answer that solved it. — user330315
– user330315, Commented Oct 13, 2014 at 15:06

user330315 · Accepted Answer · 2014-10-13 12:31:13Z

3

You need to compare the count of values, not the values itself:

select owner
from carwithowner
group by owner
having count(distinct carname) = (select count(*) from carlist)

answered Oct 13, 2014 at 12:31

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Comparing Two Result in Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related