select if appears twice
Hi!
I have this kind of table selected from database:
user project role
XXX p1 admin
XXX p2 developer
xxx p1 developer
yyy p3 tester
yyy p1 developer
yyy p1 admin
zzz p2 developer
and I need to add to this query filter - if user has at lease two roles in one project. How can I do that? What MySQL functions can help me in this case?
Subject
Written By
Posted
select if appears twice
March 11, 2017 09:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.