0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for power users of web applications

--1
select 
p.Id, count(1)
from 
    posts p
inner join (
    select 
        PostId 
    from 
        posttags 
    where 
        tagid in (4, 2) 
    group by 
        PostId 
    having 
        count(PostId) > 1
) sep on p.Id = sep.PostId
group by p.Id
having count(1) > 1

view current version

edited dec 4

created dec 4 Janis123