Articles Cookbook
8 Sep 2020
Dorota Wdzięczna

Seven Examples Using MySQL Window Functions

Window functions are an advanced SQL feature available in most popular databases. MySQL had not supported them for a long time, but that changed in Version 8.0. They are helpful not only for analysts and people who create reports, but also for other professionals who use databases to select data needed. In this article, we explain the syntax of some popular window functions with practical examples. What Is a Window Function?
Read more
4 Sep 2020
Marija Ilic

What a Moving Average Is and How to Compute it in SQL

Want to dive deep into time series data and examine long-term trends? Want to know what a moving average is and how to compute it in SQL? Then this article is for you. I’ll explain a powerful feature in SQL called window functions and show how you can calculate moving averages using them. The best way to learn about SQL window functions is the interactive Window Functions course at LearnSQL.
Read more
2 Sep 2020
Zahin Rahman

How to Find Duplicate Values in SQL — The Ultimate Guide

Find duplicate values in SQL efficiently and avoid wasting resources. This article demonstrates how to locate and address duplicate records using SQL's GROUP BY and HAVING clauses. Database best practices usually dictate having unique constraints (such as the primary key) on a table to prevent the duplication of rows when data is extracted and consolidated. However, you may find yourself working on a dataset with duplicate rows. This could be because of human error, an application bug, or uncleaned data that’s been extracted and merged from external sources, among other things.
Read more
1 Sep 2020
LearnSQL.com Team

Course of the Month: Analyzing Revenue Trends in SQL

We work hard, we learn SQL, and we develop professionally. But why? For our own satisfaction, but also for money! The knowledge of SQL will increase your income significantly. If you are proficient in SQL, you can better analyze your company's revenue. How? I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo. In this article, she answers your questions about our September SQL Course of the Month: Analyzing Revenue Trends in SQL.
Read more
28 Aug 2020
Adrian Więch

How CTEs Work

The SQL language offers a feature named Common Table Expressions, or CTEs. Also known as WITH clauses, CTEs are a fairly new addition to SQL. They help you break longer queries into smaller chunks, making your queries much easier to understand. Read the article to find out how to use CTEs and how they differ from traditional subqueries. Common Table Expressions (CTEs), which are essentially named subqueries, were first mentioned in the SQL standard between 1999 and 2000.
Read more
27 Aug 2020
Ignacio L. Bisso

How Does SQL GROUP BY Work?

Grouping results is a powerful SQL feature that allows you to compute key statistics for a group of records. GROUP BY is one of SQL’s most powerful clauses. It allows you to see data in a new way and find key metrics (like the average, maximal, and minimal values in a group of records). Without GROUP BY, all the results we obtain are oriented to records. With GROUP BY, we can create groups of records and calculate metrics on each group.
Read more
26 Aug 2020
Kateryna Koidan

SQL CTEs Explained with Examples

Learn how you can leverage the power of Common Table Expressions (CTEs) to improve the organization and readability of your SQL queries. The commonly used abbreviation CTE stands for Common Table Expression. To learn about SQL Common Table Expressions through practice, I recommend the interactive Recursive Queries course at LearnSQL.com. It contains over 100 hands-on exercises on simple and complex recursive CTEs. What does a CTE do? Why might you want to use one in your SQL code?
Read more
25 Aug 2020
Tihomir Babic

How to Calculate the Length of a Series with SQL

What is a time series and why bother to calculate its length using SQL? How do we calculate the length of a series in SQL? I can answer that in two words: window functions! Yes, you’ll need some knowledge of SQL window functions to calculate series length. But what is a time series, and why would you want to find out how long it is? What Is a Series?
Read more
21 Aug 2020
Jakub Romanowski

Where Can I Find Free Online Data Sets to Practice SQL?

Diving into the world of SQL can be an exciting journey. But to truly master this language, you need to practice SQL regularly. In this article, we'll guide you through some free online data sets that will help you take your SQL practice to the next level. Let's get started! You've successfully installed your chosen RDBMS and grasped the basics of SQL. So, what's the next step? Naturally, you're eager to apply and practice the SQL functions you've learned from our course.
Read more
20 Aug 2020
Adrian Więch

5 Examples of GROUP BY in SQL

Data grouping—or data aggregation—is an important concept in the world of databases. In this article, we’ll demonstrate how you can use the GROUP BY clause in practice. We’ve gathered five GROUP BY examples, from easier to more complex ones so you can see data grouping in a real-life scenario. As a bonus, you’ll also learn a bit about aggregate functions and the HAVING clause. SQL is a universal language to talk to databases that has been around for almost 50 years.
Read more