{"id":8847,"date":"2020-06-15T11:00:24","date_gmt":"2020-06-15T02:00:24","guid":{"rendered":"https:\/\/www.gigas-jp.com\/appnews\/?p=8847"},"modified":"2020-06-12T19:06:44","modified_gmt":"2020-06-12T10:06:44","slug":"common-aggregate-functions-in-sql","status":"publish","type":"post","link":"https:\/\/www.gigas-jp.com\/appnews\/archives\/8847","title":{"rendered":"Common Aggregate Functions in SQL"},"content":{"rendered":"\n

Today I will talk about some common aggregate functions that are widely used in SQL programming language.<\/p>\n\n\n\n

Count<\/strong><\/h4>\n\n\n\n

if we want to get the count of all records or specific where condition records, we can get by using count<\/strong> function.
<\/p>\n\n\n\n

SELECT COUNT(column_name) FROM table_name\ufeff\nSELECT COUNT(column_name) FROM table_name WHERE condition;<\/code><\/pre>\n\n\n\n
AVG<\/strong><\/h4>\n\n\n\n
For average rate calculations, we can use this.<\/p>\n\n\n\n
SELECT AVG(column_name) FROM table_name;\nSELECT AVG(column_name) FROM table_name WHERE condition;<\/code><\/pre>\n\n\n\n
SUM<\/strong><\/h4>\n\n\n\n
For sum results of all records, we can use this.<\/p>\n\n\n\n
SELECT SUM(column_name) FROM table_name\ufeff \nSELECT SUM(column_name) FROM table_name\ufeff WHERE condition;<\/code><\/pre>\n\n\n\n
MIN<\/strong><\/h4>\n\n\n\n
For specific minimum result of a column, we can use this.<\/p>\n\n\n\n
SELECT MIN(column_name) FROM table_name;\nSELECT MIN(column_name) FROM table_name WHERE condition;<\/code><\/pre>\n\n\n\n
Likewise min, we can use max<\/strong> to get maximum result.<\/p>\n\n\n\n
SELECT MAX(column_name) FROM table_name;\nSELECT MAX(column_name) FROM table_name WHERE condition;<\/code><\/pre>\n\n\n\n
By Yuuma<\/p>\n
\n            
<\/g:plusone><\/div>\n            
 \"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\"<\/a>