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 top 5
    p.Id, 
    p.tags 
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
order by p.id

view current version

edited dec 4

created dec 4 Janis123