Question

In MYSQL, _______ option causes a group function to consider only unique values of the argument expression. 

pls frds quick.....


​

Answer 1

your answer = database system, version 8.0

Answer 2

In MYSQL GROUP BY option causes a group function to consider only unique values of the argument expression.

GROUP BY

• The GROUP BY statement is a SQL instruction that groups row with the same values together.
• In the SELECT query, the GROUP BY statement is used. It can be used in conjunction with aggregate functions to generate database summary reports.
• The GROUP BY statement queries are known as grouped queries because they only return a single row for each grouped item.