Group Query Results Sql. Now again if you want to know the total amount of salary on each customer then the GROUP BY query would be as follows SQL SELECT NAME SUMSALARY FROM CUSTOMERS GROUP BY NAME. A SELECT statement clause that divides the query result into groups of rows usually for the purpose of performing one or more aggregations on each group.
SELECT agent_code SUM advance_amount FROM orders GROUP BY agent_code. Sql Group By Clause Examples on Library Database. We can see the first query results are the same as Group By Rollup example but the second query only returns 9 rows instead of 12 that we got in the Group By Rollup query.
AGENT_CODE SUMADVANCE_AMOUNT ----- ----- A004 2100 A002 3500 A007 500 A009 100 A011 900 A012 450 A010 3700 A013 3200 A001 200 A008 3300 A006 600 A005 3100 A003 1000.
Transact-SQL Syntax Conventions Transact-SQL. List the student count gruped by date quarter. In SQL groups are unique combinations of fields. The SELECT statement returns one row per group.