group by 2 columns

Question

I have a table that includes 3 columns:

How can i get the makers who produce only one product type and more than one model? The answer should output the maker and the type.

Thank you!

Possible duplicate of [Using group by on multiple columns](https://stackoverflow.com/questions/2421388/using-group-by-on-multiple-columns) — William-H-M, Mar 07 '18 at 15:32

score 1 · Answer 1 · answered Mar 07 '18 at 15:40

1

select maker, type
from your_table
where maker in
(    
    select maker
    from your_table
    group by maker
    having count(distinct type) = 1
       and count(distinct model) > 1
)

The inner select gets the makers and the outer select adds the type.

answered Mar 07 '18 at 15:40

juergen d

195,137
36
275
343

Thanks i believe that answers my question. – efi perez Mar 08 '18 at 08:52
I read a lot about Group statement but i just couldn't get the nested select. – efi perez Mar 08 '18 at 08:54
Then add the query you tried to your question. Also add the expected output and the problem or error you have with the query. – juergen d Mar 08 '18 at 09:06

group by 2 columns

1 Answers1