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 or columns?
A)GROUP BY
B)ORDER BY
C)SELECT
D)SORT BY

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 or columns. It is used to aggregate data and perform calculations on subsets of data. The ORDER BY keyword is used to sort the result set in ascending or descending order based on specified columns. The SELECT keyword is used to retrieve data from one or more tables. SORT BY is not a valid SQL keyword.

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