Re: select if appears twice

[Kamil Rosiński]

Benoit St-Jean Wrote:
-------------------------------------------------------
> You need something like this:
>
> SELECT username, project, COUNT(*) as
> number_of_roles
> FROM userprojects
> GROUP BY username, project
> HAVING COUNT(*) > 1

Thanks!

But if I'm not wrong, it will count how many roles had user.
But I need to filter users who had more than 1 role IN ONE PROJECT.