select top 1 tg, count(postid) from ( select postid, stri...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results