aggregate functions

MCQsQuestion.com has 2 Question/Answers about Topic aggregate functions

SQL standard says that sum operator should ignore an input of

SQL standard says that sum operator should ignore an input of
  • A. 0s
  • B. 1s
  • C. Null value
  • D. strings
  • Correct Answer: Option C

Groups that do not satisfy having clause predicate are

Groups that do not satisfy having clause predicate are
  • A. Applied
  • B. Removed
  • C. Retrieved accordingly
  • D. Not retrieved
  • Correct Answer: Option B