0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT
  PostHistoryTypes.Id,
  MIN(PostHistoryTypes.Name) AS Name,
  COUNT(CASE WHEN SUBSTRING(Text, 1, 2) = '{"' THEN 1 END) AS JsonCount,
  COUNT(*) AS AllCount
FROM PostHistory, PostHistoryTypes
WHERE
  PostHistory.Id % 100000 = 0
  AND
  PostHistory.PostHistoryTypeId = PostHistoryTypes.Id
GROUP BY PostHistoryTypes.Id
ORDER BY Id

view current version

edited jan 21

created jan 21 peterh - PLEASE DELETE THIS ACCOUNT