0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

select top 1 tg, count(postid) from (
	select postid, string_agg(tagid,',') within group (order by tagid) as tg, count(1) as qnt
	from posttags
	group by postid
	) a
where qnt>1
group by tg
order by count(postid) desc

fork query

edited sep 20

created sep 20 Janis123