Mar 05
Constraints are used to limit the type of data that can go into a table.
Feb 26
The CREATE TABLE statement is used to create a table in a database.
Feb 19
The CREATE DATABASE statement is used to create a database.
Feb 12
The SELECT INTO statement selects data from one table and inserts it into a different table.
Feb 05
The UNION operator is used to combine the result-set of two or more SELECT statements.
Dec 25
The FULL JOIN keyword return rows when there is a match in one of the tables.
Dec 18
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).
Dec 11
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).
Dec 04
The INNER JOIN keyword return rows when there is at least one match in both tables.
Nov 27
SQL joins are used to query data from two or more tables, based on a relationship between certain columns in these tables.
