SQL Tutorial

Aggregate functions in MySQL

In this post, we will see how to use aggregate functions in MySQL. Each function takes the column name and according to their functionality returns the numeric value.

Update and delete commands in MySQL

In this post, you will see how to use update and delete commands in MySQL. As the name suggests they are used to update or delete the data in table. But there are some important thing we need to keep in mind while using those commands.

Order by keyword and is null operator

In this post, you will see how to order the data in ascending or descending order. Also you will see how to is the field is NULL or not with IS NULL and IS NOT NULL operator.

And, or not operators

AND, OR, and NOT operators in MySQL

In this post, you will see AND, OR, and NOT operators in MySQL. How to filter data by combining these operators with WHERE clause. Also, how to combine these operators with each other.

Where Clause Blog banner

WHERE clause in MySql

In this post, you will learn about WHERE clause in MySql command line. Where clause is used to fetch data with some specific conditions. If that specific condition is met, then it return the data to print.

Fetch data using select statement

Fetch data using select keyword

In this post, you will see how to fetch data using select keyword. Also, you will see different options to use with select statement. You will see how to use distinct keyword with the select statement.