The SELECT INTO statement selects data from one table and inserts it into a different table.
The UNION operator is used to combine the result-set of two or more SELECT statements.
The FULL JOIN keyword return rows when there is a match in one of the tables.
The RIGHT JOIN keyword Return all rows from the right table (table_name2), even if there are no matches in the left table (table_name1).
The LEFT JOIN keyword returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2).
The INNER JOIN keyword return rows when there is at least one match in both tables.
SQL joins are used to query data from two or more tables, based on a relationship between certain columns in these tables.
With SQL, an alias name can be given to a table or to a column.
The BETWEEN operator is used in a WHERE clause to select a range of data between two values.
The IN operator allows you to specify multiple values in a WHERE clause.