SQL data manipulation commands
Across
- 3. by- orders the selected rows based on one or more attributes
- 4. returns the number of rows with non-null values for a given column
- 7. whether an attribute value matches any value within a value list
- 9. checks whether an attribute value is within a range
- 12. one or more rows from a table
- 13. the selection of rows based on a conditional expression
- 15. returns the maximum attribute value found in a given column
- 16. null-checks whether an attribute value is null
- 17. restores data to their original value
- 18. whether a sub query returns any rows
Down
- 1. the selection of grouped rows based on a condition
- 2. attributes from rows in one or more tables or views
- 5. modifies an attribute values in one or more tables rows
- 6. whether an attribute value matches a given string pattern
- 8. returns the minimum attribute value found in a given column
- 10. BY-groups the selected rows based on one or more attributes
- 11. returns the average of all values for a given column
- 14. returns the sum of all values for a given column
- 19. inserts rows into a table