find top tags by count

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @NumberOfRows int = ##NumberOfRows##

SELECT TOP ##NumberOfRows##
  TagName
  , [Count]
  
FROM
  Tags
  
WHERE
  Tags.TagName COLLATE SQL_Latin1_General_CP1_CI_AS LIKE ##EnterKeyword:string##
  
ORDER BY
  [Count] DESC
  
-- NumberOfRows: Number of Records
-- EnterKeyword: Enter tag or keyword

Enter Parameters

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