Today I was asked to pull some data and give a total of a specific column in a table in SQL. I then realized that not everyone would have came across this. With that said, I thought I would type up this little blog to explain and show it to you. Use the SUM() Function to get the total of a specific numeric column. Below is the specific syntax to use. SQL SUM Example:
Please note, you can also preform formulas and groupings while using this function as well. I will show you those at a later date.