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

Informatics Practices

DISTINCT option causes a group function to consider only the unique values of the argument expression.

SQL Queries

Answer

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.