which query is used for grouping and summarizing data
Answers
Answer:
In T-SQL, you summarize data by using the GROUP BY clause within an aggregate query. This clause creates groupings which are defined by a set of expressions.
Explanation:
The SQL GROUP BY Clause is used to output a row across specified column values. It is typically used in conjunction with aggregate functions such as SUM or Count to summarize values. In SQL groups are unique combinations of fields.The SQL GROUP BY clause allows us to group individual data based on defined criteria. You can group individual data by one or more table columns. In order to do the grouping properly, you often need to apply aggregate functions to the column(s) within the SQL SELECT statement.
hope it helps you...
please follow me and give thanks to my all answers please please....
mark me as brainliest please...
Answer:
In T-SQL, you summarize data by using the GROUP BY clause within an aggregate query. This clause creates groupings which are defined by a set of expressions.
Explanation:
Hope it's helpful...
pls mark me brainliest...