Course

### What is the SQL SUM() function?

### What is the difference between SUM() and COUNT() functions?

### How does the SUM() function handle NULL values?

### Can one use the DISTINCT keyword with the SUM() function?

### How can you use the SUM() function with window functions?

### What other functions in SQL are similar to SUM()?

Topics

Learn SQL with DataCamp

2 hr

741.3K

Course

### Joining Data in SQL

4 hr

147.7K

Course

### Data Manipulation in SQL

4 hr

226.2K

See More

RelatedSee MoreSee More

tutorial

### Aggregate Functions in SQL

Learn how to use aggregate functions for summarizing results and gaining useful insights about data in SQL.

Sayak Paul

9 min

tutorial

### COUNT() SQL FUNCTION

COUNT() lets you count the number of rows that match certain conditions. Learn how to use it in this tutorial.

Travis Tang

3 min

tutorial

### How to Use the SUMX Power BI Functions

Explore the SUMX function in Power BI, its syntax, how it works, and best practices to keep in mind.

Joleen Bothma

8 min

tutorial

### How to Use GROUP BY and HAVING in SQL

An intuitive guide for discovering the two most popular SQL commands to aggregate rows of your dataset

Eugenia Anello

6 min

tutorial

### SQL: Reporting and Analysis

Master SQL for Data Reporting & daily data analysis by learning how to select, filter & sort data, customize output, & how you can report aggregated data from a database!

Hafsa Jabeen

37 min

tutorial

### Understanding the LAG() Function in SQL: A Comprehensive Guide

Explore how the LAG() function allows you to access previous rows in your dataset, enabling time series analysis and comparisons of sequential observations.

Islam Salahuddin

11 min