0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for music historians, critics, and fans

select top 5 targettagname, count(sourcetagname) as counts 
into #tempTable
from tagsynonyms
group by targettagname
order by count(sourcetagname) desc

select distinct t.targettagname, s.sourcetagname
from #tempTable t
left join tagsynonyms s
on t.targettagname = s.targettagname

fork query

edited nov 7

created nov 7 anonymous