SQL Archives

How To Use FULL OUTER JOIN Keyword In SQL

Yasin Panwala Nov 16, 2019 0 718

In this article, we will learn how to use the FULL OUTER JOIN keyword in SQL. The FULL OUTER JOIN is also known as FULL JOIN.

The FULL OUTER JOIN keyword is used to select all records from both tables.

The columns of the left table will have nulls when no matching rows exist for the row in the right table. Similarly, The columns of the right table will have nulls when no matching rows exist for the row in the left table.

How To Use RIGHT JOIN Keyword In SQL

Yasin Panwala Nov 16, 2019 0 632

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

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

How To Use LEFT JOIN Keyword In SQL

Yasin Panwala Nov 11, 2019 0 733

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.

How To Use INNER JOIN Keyword In SQL

Yasin Panwala Nov 11, 2019 0 698

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.

How To Use Alias In SQL

Yasin Panwala Nov 11, 2019 0 726

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.

How To Use BETWEEN Operator In SQL

Yasin Panwala Nov 11, 2019 0 676

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.

How To Use IN, NOT IN Operator In SQL

Yasin Panwala Nov 11, 2019 0 685

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

The IN operator can be used to specify multiple values in a WHERE clause.

The IN operator is a shorthand, to remove the need of multiple OR conditions.

How To Use LIKE Operator With Wildcard Characters In SQL

Yasin Panwala Nov 11, 2019 0 976

In this article, we will learn how to use the LIKE operator with wildcard characters in SQL.

To substitute one or more characters in a string a Wildcard character is used.

Wildcard characters are used with the LIKE operator in SQL. To search for a specified pattern in the column, The LIKE operator is used in a WHERE clause.

How To Use LIKE Operator In SQL

Yasin Panwala Nov 9, 2019 0 775

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.

How To Use TOP Clause In SQL

Yasin Panwala Nov 9, 2019 0 725

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

The SELECT TOP clause is used to specify the number/percent of records to return.

The SELECT TOP clause is useful with thousands of records on large tables.