Database - Introduction to SQL

The condition in a WHERE clause can refer to only one value.

The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.

The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.