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, 1273🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...