Informatics Practices
DISTINCT option causes a group function to consider only the unique values of the argument expression.
SQL Queries
1 Like
Answer
True
Reason — The DISTINCT keyword, when used with group functions (such as COUNT, SUM, AVG), ensures that only unique values of the specified column or expression are considered in the calculation, thereby eliminating duplicates from the result set.
Answered By
1 Like
Related Questions
The ORDER BY clause combines all those records that have identical values in a particular field or a group of fields.
The WHERE clause is used to specify filtering conditions for groups.
By default, ORDER BY clause sorts the result set in descending order.
COUNT() function ignores null values while counting the records.