How To Use LEFT JOIN Keyword In SQL

In this article, we will learn how to use the LEFT JOIN keyword in SQL.

The LEFT JOIN keyword is used to select all records from the table1 (left table), and the matched records from the table2 (right table). If there is no match, the result from the right side is NULL.

Read More

How To Use INNER JOIN Keyword In SQL

In this article, we will learn how to use the INNER JOIN Keyword in SQL.

The INNER JOIN keyword is used to select records that have matching values in both tables.

The INNER JOIN keyword selects all rows from both tables until there is a match between the columns.

Read More

How To Use Alias In SQL

In this article, we will learn how to use aliases with SQL queries.

To make column names more readable, Aliases are used.

SQL aliases are used to give a temporary name to a table, or a column in a table. An alias only exists for the duration of the query.

Read More

How To Use BETWEEN Operator In SQL

In this article, we will learn how to use the BETWEEN operator with a SQL select query.

The BETWEEN operator is used to select values within a given range, begin and end values are also included in that. The values can be numbers, strings, or dates.

Read More

How To Use LIKE Operator In SQL

In this article, we will learn how to use the LIKE operator with a SQL select query.

To search for a specified pattern in the column, The LIKE operator is used in a WHERE clause.

Usually, there are two wildcards used in conjunction with the LIKE operator:

% (Percent): It can be used to represents zero, one, or multiple characters.
_ (Underscore ): It can be used to represents a single character.

The % (Percent) and the _ (Underscore) can also be used in combinations.

Read More