Computer Science
Which of the following is a SQL aggregate function ?
- LEFT
- AVG
- JOIN
- LEN
SQL Joins & Grouping
1 Like
Answer
AVG
Reason — Aggregate functions in SQL include AVG, COUNT, MAX, MIN, and SUM.
Answered By
1 Like
Related Questions
Which of the following is not an aggregate function ?
- Avg
- Sum
- With
- Min
All aggregate functions except …………… ignore null values in their input collection.
- Count(attribute)
- Count(*)
- Avg
- Sum
Which of the following group functions ignore NULL values ?
- MAX
- COUNT
- SUM
- All of the above
The functions which work with individual rows' data are called …………… function.
- Single row
- Multiple rows
- Aggregate
- None of these