0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーとプログラミングに熱心な人々のための質問と回答

SELECT date1, count(id) as count
FROM (

  SELECT 
    FORMAT (p.CreationDate, 'yy-MM') as [date1],
    (p.Id) as id
  FROM Posts p
    
  WHERE
    p.PostTypeId = 1  -- 1=Question
    
  ) as t1
group by date1
order by date1

fork query

edited feb 29 anonymous

created jul 9 19 Moradnejad