0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

SELECT TOP 100 count(v.postid) AS 'Vote count', v.postid AS [Post Link],p.body
FROM votes v 
INNER JOIN posts p on p.id=v.postid
WHERE p.tags LIKE N'go'
GROUP BY v.postid,p.body
ORDER BY 'Vote count' DESC

fork query

edited jun 3 Eklavya

created oct 16 19 dynamicwebpaige