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 or columns?

a) WHERE

b) GROUP BY

c) ORDER BY

d) SORT BY

Answer 1

The SQL keyword used with built-in functions to group together rows that have the same values in a specified column is GROUP BY. It is essential in queries that use aggregate functions to organize the results set into unique groups based on one or more columns. So the correct answer is option B.

Step-by-step explanation:

In an SQL query, to group together rows that have the same value in a specified column or columns, the GROUP BY keyword is used. This keyword is often paired with aggregate functions like COUNT, SUM, AVG, MAX, and MIN, allowing you to perform calculations on each group of rows in the result set.

For example, if you wanted to count the number of customers from each country in a database, you might use a query like: SELECT Country, COUNT(*) FROM Customers GROUP BY Country;

This would output a list of countries along with the number of customers from each country, with the GROUP BY clause ensuring that the results are separated by country.