Articles
Week 3: Articles
The articles for this week focus on the Data Manipulation Language (DML) INSERT
statement, scalar subqueries, and automatic numbering. Scalar subqueries are SELECT
statements that return one column and one row from a table; and they are typically used to find a surrogate key by using the natural key in the WHERE
clause. Automatic numbering uses sequence values to populate what are known as surrogate key columns or ID columns.
You should read the
article first and then either the scalar subquery or automatic numbering articles.INSERT
Articles