In an SQL query,which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column?
A)GROUP BY
B)ORDER BY
C)SELECT
D)SORT BY
E)DISTINCT SET

Question

Quizplus · Accepted Answer

The GROUP BY keyword is used with built-in functions to group together rows that have the same value in a specified column. It enables aggregation and summarization of data based on common values in a column. Options B) ORDER BY, C) SELECT, D) SORT BY, and E) DISTINCT SET do not serve the same purpose as GROUP BY in SQL.

In an SQL Query,which SQL Keyword Is Used with Built-In