Mar 05

Constraints are used to limit the type of data that can go into a table.

Continue Reading »

Feb 26

The CREATE TABLE statement is used to create a table in a database.

Continue Reading »

Feb 19

The CREATE DATABASE statement is used to create a database.

Continue Reading »

Feb 12

The SELECT INTO statement selects data from one table and inserts it into a different table.

Continue Reading »

Feb 05

The UNION operator is used to combine the result-set of two or more SELECT statements.

Continue Reading »

Dec 25

The FULL JOIN keyword return rows when there is a match in one of the tables.

Continue Reading »

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).

Continue Reading »

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).

Continue Reading »

Dec 04

The INNER JOIN keyword return rows when there is at least one match in both tables.

Continue Reading »

Nov 27

SQL joins are used to query data from two or more tables, based on a relationship between certain columns in these tables.

Continue Reading »