Question

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

Answer 1

The SQL keyword used to group together rows with the same value is GROUP BY.

Step-by-step explanation:

The SQL keyword used to group together rows that have the same value in a specified column is GROUP BY. It is commonly used in combination with built-in functions to aggregate data. For example, if you have a table of sales data and you want to calculate the total sales for each product, you can use the GROUP BY clause along with the SUM function.