in clause to match all items

1. <code>
2. </code>

<code>
</code>

    select * from ItemsPackage where ItemId IN (3,5,2)
    select * from ItemsPackage where ItemId IN (3,5,2)

1. <code> select * from ItemsPackage where ItemId IN (3,5,2)
2. </code>

<code>    select * from ItemsPackage where ItemId IN (3,5,2)
</code>

This will be match as OR Expression
to make it get ALL item Id you can make it :

    select PakageId
    from ItemsPackage 
    where ItemId in (3,5,2)
    group by PakageId
    having count(PakageId) = 3 -- Count of In clause (3,5,2)
    select PakageId
    from ItemsPackage 
    where ItemId in (3,5,2)
    group by PakageId
    having count(PakageId) = 3 -- Count of In clause (3,5,2)

1. <code>
2. select PakageId
3. from ItemsPackage
4. where ItemId in (3,5,2)
5. group by PakageId
6. having count(PakageId) = 3 -- Count of In clause (3,5,2)
7. </code>

<code>
    select PakageId
    from ItemsPackage 
    where ItemId in (3,5,2)
    group by PakageId
    having count(PakageId) = 3 -- Count of In clause (3,5,2)
</code>