You would like to group all your data by year and calculate the total ... To retrieve a year from the date in SQL Server, you can use the YEAR() function.
確定! 回上一頁