## SQL GROUP BY Guide

Use the SQL GROUP BY Clause is to consolidate like values into a single row.  The group is a set of columns. The group

SQL GROUP BY Guide

## SQL SUM Function

The SQL SUM function returns the total value within a table or group. In its simplest use, SUM() totals a column for all results and returns a

SQL SUM Function

## What is the difference between WHERE and HAVING clauses?

In this article learn when to use WHERE and HAVING.  Both perform similar functions, but for different purposes! All the examples for

What is the difference between WHERE and HAVING clauses?

## SQL COUNT Function

The SQL COUNT function is an aggregate function used to count rows.  Use it alone within a SELECT statement to return a count of all rows within

SQL COUNT Function

## SQL APPROX_COUNT_DISTINCT Function

Use the Approximate Count Distinct function, APPROX_COUNT_DISTINCT, to return an estimate distinct count of values withing rows. It is best suited for

SQL APPROX_COUNT_DISTINCT Function

## SQL MIN Function

The SQL MIN function returns the smallest value within a table or group.  Throughout this section we’ll use the HumanResource.Employee table for our examples:  Using the

SQL MIN Function

## SQL MAX Function

The SQL MAX function returns the largest value within a table or group. In this section, we’ll use the HumanResource.Employee table for our examples:  Using the data above, MAX calculates

SQL MAX Function

## SQL AVG Function

The SQL AVG function returns the average value within a table or group. In this section, we’ll use the HumanResource.Employee table for our examples: Using sample data above, AVG calculates

SQL AVG Function

## SQL Pivot Table – Learn to Create in Six Steps

In this episode of SQL Minute I want to share with you how to create a pivot or cross tab chart. I’ll

SQL Pivot Table – Learn to Create in Six Steps

## Use SQL to Calculate a Running Total

The running total in SQL can be calculated in several ways. This article will cover two methods:  the Joins and the Window functions.

Use SQL to Calculate a Running Total

## What is a Dynamic Pivot Table?

In this puzzle, we’re going to learn how to create a dynamic pivot table using SQL Server.  A dynamic pivot table is

What is a Dynamic Pivot Table?

## What is the Difference between ORDER and GROUP BY?

Both the GROUP and ORDER BY clauses are used in organizing data. Find out which of the two is used to sort

What is the Difference between ORDER and GROUP BY?