This tutorial introduces you to the most commonly used SQL aggregate functions including AVG, COUNT, MAX, MIN and SUM functions.

In this tutorial, you'll learn how to use the SQL ANY_VALUE() aggregate function to select any value from a group.

This tutorial shows you how to use the SQL SELECT statement to retrieve data from a single table.

This SQL Tutorial helps you master SQL quickly and effectively through many hands-on and practical examples with quizzes.

In this tutorial, you'll learn how to use the SQL RIGHT function to return a specified number of characters from the end of a string.

Summary: In this tutorial, you’ll understand the databases and SQL, the standard language for interacting with the databases. Introduction to databases A database is a structured collection …

This tutorial introduces you to the SQL correlated subquery, which is a subquery that uses values from the outer query.

This tutorial shows how to use SQL RANK() function to find ranks of rows in a result set. It provides some practical applications of the RANK() function.

In this tutorial, you will learn how to find the maximum value in a group using the SQL MAX aggregate function.

Summary: in this tutorial, you will learn how to use SQL AVG function to calculate the average value of a set of values. Introduction to SQL AVG function The AVG function is an aggregate …