Login / Signup

Question

Aggregate function in SQL

A An aggregate function in SQL performs a calculation on multiple values and returns a single value.

B avg, count, sum, min, max are aggregate function

C An aggregate function ignores NULL values when it performs the calculation, except for the count function

D All three are correct

E None

Practice Next

More Basics of Computers Questions

Which of the following is a key difference between distributed computing and cloud computing?
Which of the following is an example of application software?
In the context of web development, which of the following best describes the primary difference between HTTP and HTTPS?
Data Frame are associated with which layer of OSI Model
What will be the output of the following code snippet? class Animal: def sound(self): return "Some sound" class Dog(Animal): def sound(sel...
What will be the output of the following Java code snippet, which implements a simple ArrayList and performs an insertion and a retrieval? import java.u...
What is the main purpose of the AJAX technique in web development?
In a Min-Heap, the node at index i has a value of 12, and the node at index i*2 + 1 has a value of 15. Which of the following statements is correct?
Which protocol among the following is responsible for the remote management of network devices?
Which generation of computers is characterized by the use of Transistors as their primary electronic component?

Hey! Ask a query

ask-question