SQL Data Manipulation Commands

Edit Answers
123456789101112131415161718192021
Across
  1. 2. Checks whether an attribute value matches a given string pattern.
  2. 5. Selects attributes from rows in one or more tables.
  3. 6. Checks whether an attribute value matches any value within a value list.
  4. 7. Checks whether an attribute value is within a range.
  5. 9. Permanently saves data changes.
  6. 10. Returns the number of rows with non-null values for a given column.
  7. 11. Returns the sum of all values for a given column.
  8. 14. Restricts the selection of grouped rows based on a condition.
  9. 19. Modifies an attribute's values in one or more table's rows.
  10. 21. Restores data to their original values.
Down
  1. 1. Deletes one or more rows from a table.
  2. 3. Inserts row(s) into a table.
  3. 4. Limits values to unique values.
  4. 8. Checks whether a subquery returns any rows.
  5. 12. Returns the minimum attribute value found in a given column.
  6. 13. Restricts the selected rows based on a conditional expression.
  7. 15. Returns the average of all values for a given column.
  8. 16. Checks whether an attribute value is null.
  9. 17. Groups the selected rows based on one or more attributes.
  10. 18. Orders the selected rows based on one or more attributes.
  11. 20. Returns the maximum attribute value found in a given column.