SELECT (sum(stock_1)/12) AS average_stock FROM (SELECT lp.stock_1 ,ROW_NUMBER() OVER (PARTITION BY YEAR(date), Month(date) ORDER BY date ASC) 'RowRank' FROM sl_h.dbo.reports lp WHERE stock_1 > 0 )sub WHERE RowRank = 1

https://stackoverflow.com/questions/17436868/get-last-record-from-each-month

end of month and only 12 SELECT top 12 stock_1 AS average_stock ,[date] FROM (SELECT s.[date], s.stock_1 ,ROW_NUMBER() OVER (PARTITION BY YEAR(date), Month(date) ORDER BY date DESC) 'RowRank' FROM sl_h.dbo.reports s WHERE stock_1 > 0 )sub WHERE RowRank = 1 ORDER by [date] desc 21.04.20 SELECT TOP 12 [date] ,stock_1 AS stock FROM (SELECT s.[date],s.stock_1 ,ROW_NUMBER() OVER (PARTITION BY YEAR(date), Month(date) ORDER BY date DESC) 'RowRank' FROM sl_h.dbo.reports s WHERE stock_1 > 0 )sub WHERE RowRank = 1 ORDER by [date] desc 21.04.20

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024