Database - Introduction to SQL

Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

The keyword LIKE can be used in a WHERE clause to refer to a range of values.

The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."