Which one the following is not considered an aggregate function?

The correct answer is C. SELECT. The SELECT statement is a fundamental SQL command for retrieving data from a database, distinct from aggregate functions that perform calculations on groups of rows.

Data Concepts and Environments

Question

Options

ASUM
BMIN
CSELECT
DMAX

How the community answered

(31 responses)

A
3% (1)
B
6% (2)
C
90% (28)

Why each option

The `SELECT` statement is a fundamental SQL command for retrieving data from a database, distinct from aggregate functions that perform calculations on groups of rows.

ASUM

`SUM` is an aggregate function that calculates the total sum of a set of values.

BMIN

`MIN` is an aggregate function that returns the smallest value in a set.

CSELECTCorrect

`SELECT` is a SQL keyword used to query data from a database, specifying which columns to retrieve, and it does not perform an aggregate calculation across a set of rows. Aggregate functions, in contrast, operate on a collection of input values and return a single scalar value.

DMAX

`MAX` is an aggregate function that returns the largest value in a set.

Concept tested: SQL aggregate functions vs. statements

Source: https://learn.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql

Topics

#SQL#Aggregate Functions#Database Concepts

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice