Skip to navigation
Average a sum with mssql
14.06.19
use AVG SELECT t.shr_currency ,AVG(t.shr_rate) as exchange_rate FROM sl.dbo.shr_rate AS t WHERE t.shr_currency = 'THA' AND year(t.shr_date) = 2019 AND month(t.shr_date) = 6 GROUP BY t.shr_currency
http://datenbanken-verstehen.de/sql-funktionen/sql-avg-funktion/
Reply
Anonymous
Information Epoch 1757974575
Worse is better.
Home
Notebook
Contact us
