Collections:
Using Group Functions in the SELECT Clause in SQL Server
How To Use Group Functions in the SELECT Clause in SQL Server?
✍: FYIcenter.com
If group functions are used in the SELECT clause, all rows that meet the criteria defined in the WHERE clause will be treated as a single group. The group functions will be apply all rows in that group as a whole. The final output of the SELECT statement is the resulting values of the group functions, not the rows in the group.
Here are two good examples of using group functions :
SELECT COUNT(*), MAX(counts), MIN(created) FROM fyi_links GO COUNT(*) MAX(counts) MIN(created) 7 972 2003-01-01 SELECT COUNT(*), MAX(counts), MIN(created) FROM fyi_links WHERE tag = 'DBA' GO COUNT(*) MAX(counts) MIN(created) 3 972 2005-01-01
In first case, the group contains all the rows in table fyi_links, because is no WHERE clause. In the second case, the group contains only 3 rows because of the WHERE clause tag = 'DBA'.
⇒ Mixing Group Functions with Non-group Selection Fields in SQL Server
⇐ Group Functions in Query Statements in SQL Server
⇑ Using SELECT Statements and GROUP BY Clauses in SQL Server
2016-10-25, 1741🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...