Across
- 3. A temporary result not stored as an object and lasts only for the duration of the query
- 4. Retrieve specific information from a table excluding other irrelevant data
- 6. An aggregate function returns average of values
- 10. Returns the first non-null expression among its arguments
- 12. Most commonly used SQL command
- 14. Returns a null value if the two specified expressions are equal
Down
- 1. Keyword used to retrieve records without duplication
- 2. A mathematical function that returns the absolute value of a number
- 5. A statement used to run the stored procedure
- 7. Summarizes the result set using aggregate functions
- 8. A temporary intra query substitute for a table name or column name
- 9. A constraint which is used to limit the value range
- 11. Select query within another select query
- 13. Specifies a subquery to test for the existence of rows