The SUM() function in SQL returns the total sum of a numeric column. It's commonly used to calculate totals in datasets like sales, quantities, or prices.