Sooner or later, you want to know when a column contains in SQL another value.  In this article we’ll go over several

Read More
Contains in SQL

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

Its is easy to get confused between inner join vs outer join clauses. Both inner and outer joins are used to combine

Read More
Inner Join vs Outer Join Clauses

The SQL FULL JOIN combines results from a left and right outer join into one result.  Or in other words, it is an inner join including

Read More
SQL FULL Join

The SQL RIGHT JOIN Includes all rows from the Right table and those that match from the left.  For that doesn’t match from the right, NULL is returned in the

Read More
SQL Right Join

The SQL LEFT JOIN Includes all rows from the left table and those that match from the right table. When the right table doesn’t match the

Read More
SQL Left Join

SQL Joins are important to master. As you progress from a beginner to advanced beginner, you’ll soon need to combine data from

Read More
SQL Joins – The Ultimate Guide

Use SQL cross joins when you wish to create a combination of every row from two tables.  All row combinations are included

Read More
SQL Cross Join

Use an SQL INNER JOIN when you need to match rows from two tables.  Rows that match remain in the result, those

Read More
SQL Inner Join

In a SQL self join the table is joined to itself.  You can think of it being like an inner join. The

Read More
SQL Self Join

In this puzzle, we’re going to learn how to calculate moving averages by working through a hypothetical stock market example. Solving puzzles

Read More
SQL Puzzle:  How to Calculate Moving Averages

Recursive CTE’s Recursive CTEs are unique, such that they are allowed to reference their own. With this special ability, you can use

Read More
What is a Recursive CTE (Common Table Expression)?

The Common Table Expressions or CTE’s for short are used within SQL Server to simplify complex joins and subqueries, and to provide

Read More
Common Table Expressions – The Ultimate Guide

A reader recently asked me to help them solve a problem combining data from multiple tables into a single result.  What was

Read More
Is it possible to use Joins, Subqueries, and Unions on Multiple Tables?

Many times in a relational database the information you want to show in your query is in more than one table.  This

Read More
How do I combine results from several SQL tables (hint: there are three ways)