[SQL] Matching several rows

[Ivan Steganov]

Hi,

This is possibly absolutely trivial but I am lost...

A table URIGHTS which stores an ID and the RIGHTs this ID has. One ID may have many rights and accordingly records in table, sample:

ID        RIGHT
---------------------
20        1
20        2
20        5
20        10
30        2
30        10

Now I need to find out which IDs have, say rights 2 AND 5 AND 10.

What would be the simplest query?

Thanks!