SQL Crossword Puzzle

12345678910
Across
  1. 2. Used to give a table, or a column in a table, a temporary name
  2. 5. In the query, SELECT TOP 20 last_name FROM accounts, this is the number of records returned.
  3. 7. Operator used to combine the result-set of two or more SELECT statements with columns with the same data type in the same order.
  4. 9. Clause used to specify the number of records to return.
  5. 10. Statement used with aggregate functions to pool the result-set by one or more columns.
Down
  1. 1. Statement used to filter records
  2. 3. In the query, SELECT last_name FROM accounts, the column is being pulled from this table.
  3. 4. Clause used to combine rows from two or more tables, based on a related column between them.
  4. 6. Operator used to substitute one or more characters in a string
  5. 8. Operator is a shorthand for multiple OR conditions