Use SQL HAVING to filter summary results from a GROUP BY.  It specifies the search condition for the group or aggregate. SQL

Read More
SQL HAVING Tutorial

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

Read More
SQL GROUP BY Guide

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

Read More
What is the difference between WHERE and HAVING clauses?

In this article you’ll learn to use the LIKE operator in your SQL. In most situations you’ll find yourself using LIKE within

Read More
SQL WHERE LIKE

In this video we’ll walk you though how to use the LIKE clause.   We’ll show you how to you can perform

Read More
How do I use the Like Clause in SQL Server?

In today’s lesson, you’re going to learn how to filter query results using the SQL WHERE clause.  This clause is important as

Read More
SQL WHERE – Guide and Examples

The SQL ORDER BY clause is used to sort your query result in ascending or descending order. Once you have written a

Read More
Use SQL ORDER BY to Sort Results

Both TOP and OFFSET & FETCH can be used to limit the number of rows returned.  OFFSET and FETCH can return similar

Read More
What is the Difference between TOP and OFFSET & Fetch?

In this article we explore the OFFSET and FETCH clauses.  OFFSET and FETCH are used in conjunction with the SELECT statement ORDER

Read More
Using OFFSET and FETCH with the ORDER BY clause

Some times you just need to use SQL TOP to reduce the number of rows shown in your result. This is handy

Read More
SQL TOP

You will learn how to query Microsoft SQL Server using the SQL SELECT statement in this series of lessons. Once you have

Read More
SQL SELECT

The SQL In operator compare a column to a list. In this article we’ll see how to use In and NOT IN

Read More
SQL In Operator

Knowing the order of execution in SQL helps you better understand SQL’s “hair pulling” errors! As you start to work with SQL

Read More
Order of Execution in SQL Explained

Hey, welcome back to another SQL Minute. Today we’re going to learn how to code like a boss by delving into formatting

Read More
Automatically Format Your SQL

The knowledge of SQL has always been in demand. Even if you don’t have a job as a data analyst or any

Read More
An Ultimate Guide to Write an SQL Query

The SQL Less Than Or Equal To comparison operator (<=) is used to compare two values.  It returns TRUE if the first value is less than the second. 

Read More
SQL Less Than or Equal To

The SQL Greater Than or Equal To comparison operator (>=) is used to compare two values.  It returns TRUE if the first value is greater than or

Read More
SQL Greater Than or Equal To Comparison Operator

The SQL Less Than comparison operator (<) is used to compare two values.  It returns TRUE if the first value is less than the second.  If the second

Read More
SQL Less Than Comparison Operator

The SQL Greater Than comparison operator (>) is used to compare two values.  It returns TRUE if the first value is greater than the second.  If the

Read More
SQL Greater Than Comparison Operator

Rename Columns with SQL SELECT AS You can use a form of SQL SELECT AS to rename columns in your query results.

Read More
SQL SELECT AS

Most people are familiar enough with basic SQL to be able to provide a simple explanation of it. Unfortunately, few know how

Read More
Basic SQL: A Business User’s Guide to Writing Queries

In this video we’ll walk you through how to include a single quote in a SQL query; we’ll show how to escape

Read More
How to include a single quote in a SQL query

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

Read More
Use SQL to Calculate a Running Total

This article is inspired by a series of questions that one of my readers, Nan, recently sent me regarding SQL DISTINCT, TOP,

Read More
SQL DISTINCT and TOP in Same Query

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

Read More
What is the Difference between ORDER and GROUP BY?