Computer Science
Which of the following is not an aggregate function ?
- Avg
- Sum
- With
- Min
SQL Joins & Grouping
1 Like
Answer
With
Reason — Aggregate functions in SQL include AVG, COUNT, MAX, MIN, and SUM.
Answered By
1 Like
Related Questions
The operation whose result contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
- Join
- Cartesian product
- Intersection
- Set difference
Which SQL function is used to count the number of rows in a SQL query ?
- COUNT()
- NUMBER()
- SUM()
- COUNT(*)
All aggregate functions except …………… ignore null values in their input collection.
- Count(attribute)
- Count(*)
- Avg
- Sum
Which of the following is a SQL aggregate function ?
- LEFT
- AVG
- JOIN
- LEN