SQL - Structured Query Language |
GROUP BY ClauseGROUP BY clause is used to selected set of rows into a set for summary rows by the values of one or more columns or expressions in SQL Server 2012. One row is returned for each group. Aggregate functions in the SELECT clause --
Example 28 -- SELECT COUNT(*), Prod_Tax FROM Product GROUP BY Prod_Tax SELECT MIN(Exp_Date) FROM Product GROUP BY Exp_Date SELECT MAX(Exp_Date) FROM Product GROUP BY Exp_Date SELECT AVG(Prod_Tax) FROM Product GROUP BY Prod_Tax SELECT SUM(Prod_Tax) FROM Product GROUP BY Prod_Tax |
* * * * *