Problem We want to compare two moving averages in SQL. We’ll use
This archive contains slew of posts on how to use SQL to solve problem. If you have a question about a particular issue, or technique, you may find a solution here.
For instance, here is one of our more “fun” article on how to use SQL to create a bar chart: How to Create A Bar Chart Using SQL Server
If you’re studying for the 70-761 Querying Microsoft SQL Server certification, these two articles are a must read:
How to Create a 70-761 Study Plan Today!
9 Best Study Tips for 70-761 Certification
All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters. You can get started using these free tools using my guide Getting Started Using SQL Server
Problem You want to remove duplicates in SQL. You know it is easy to find duplicates using GROUP BY, but how do
Problem You need to find duplicates and then identify the records by their primary keys. Background Here’s an example of how to
In this article I’ll show you how to use STRING_SPLIT() to join two tables. I call this the impossible join. I’ve come
In this video we’ll walk you though how to use the LIKE clause. We’ll show you how to you can perform
Many times in a relational database the information you want to show in your query is in more than one table. This
When working with NULL, you’ll often find yourself wanting to replace these “missing” values, with something else. Just use ISNULL to do
If you want to find duplicate rows in SQL, you can go two routes. The first is to use the GROUP BY
If you have ever have wanted to start learning SQL but didn’t know where to start because you were frustrated, then let
Hey, welcome back to another SQL Minute. Today we’re going to learn how to code like a boss by delving into formatting
In the 70-761 exam covers the SQL Server 2016. Since this exam covers the data query, most of the topics that are
This is the first in a series of articles on how to Get Started with Power BI. For those of you unaware,
A reader recently asked about a error converting data type error they received. Since this is a common issue, especially when numeric
In this video we’ll walk you though how to use the CHOOSE function with SELECT. You’ll see how the function works and
Over the years there I’ve seen students makes these common SQL mistakes. They are really easy to avoid, and once you know
In this video we’ll walk you through how to include a single quote in a SQL query; we’ll show how to escape
In this video we’ll walk you though how to use the IN operator with a Subquery; we’ll show you why you would
In this video we’ll walk you though how to use the SQL IN operator; we’ll show you why you would want to
In this video we’ll walk you though how to use the SQL BETWEEN operator; we’ll show you why you would want to
The running total in SQL can be calculated in several ways. This article will cover two methods: the Joins and the Window functions.
Studying and preparing for the 70-761 can be intimidating. There are many topics you need to cover, but with so little time.
In this puzzle, we are going to learn how to join dirty data using the SQL Server. There are many instances that
We are going to learn how to create a bar chart using SQL server in this puzzle. It can sometimes be fun
Select Top Rows In this video we’ll walk you though how to select top rows within a query. We’ll show you
When working with SQL dates, sometimes you need to calculate the end of the month. Months are tricky! Some are 28 days,
You can do this! Pass exam 70-461. It may seem intimidating, but you can pass Exam 70-461 Querying SQL Server. All it