How can one select only the items he want in the IN list? for example

select * from pagetags where TagID in (1,2,4)

Now I want all the pages which has all the above 3 IDs assigned to them (1,2,4), not just any of them but all of them?

Is there a way? any other operator? I have already tried = Any and = All but no luck.

sql-server t-sql
Edit
Report