How do I use the SUM function in SQL?

How do I use the SUM function in SQL?

The SUM function in SQL is used to calculate the total sum of a numeric column. You can use it in a SELECT statement like this: SELECT SUM(column_name) FROM table_name;

Can I use SUM with a WHERE clause?

Yes, you can use SUM with a WHERE clause to filter the rows before summing. For example: SELECT SUM(column_name) FROM table_name WHERE condition;

What if I want to group the results?

You can use the GROUP BY clause to group the results. For example: SELECT column_name, SUM(another_column) FROM table_name GROUP BY column_name;

Can I use SUM with multiple columns?

The SUM function can only be applied to one column at a time, but you can include multiple SUM functions in your query. For example: SELECT SUM(column1), SUM(column2) FROM table_name;