How to SUM and SUBTRACT using SQL?

To perform SUM and SUBTRACT operations in SQL, you can use the following methods:

1. SUM:

The SUM() function adds up all values in a specified column. It’s typically used with GROUP BY for aggregating data.

SELECT SUM(ColumnName) AS Total
FROM YourTable;

2. SUBTRACT:

To subtract values in SQL, you can use the – operator directly within a query.

SELECT Column1 – Column2 AS Difference
FROM YourTable;

You can also subtract values between rows using JOIN or WHERE clauses for more complex calculations.