In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
aggregate function query
The greatest feature of aggregate functions is that they evaluate a value from a set of data. The result value of the aggregate function is calculated only from non-NULL values in the selected row; NULL values are ignored.
COUNT() function
COUNT() function returns the number of rows in the selected set that are not NULL values for any parameter except "*"; returns the number of all rows in the selected set that contain NULL values for parameter "*." COUNT(*) without a WHERE clause is internally optimized to quickly return the total number of all records in the table.
Examples:
select COUNT(*) from info;
Search Results:
SUM() function
The SUM() function sums the values of a field in a table.
Examples:
select SUM(score) from info;
Search Results:
AVG() function
The AVG() function averages the values of a field in a table.
Examples:
select avg(score) from info;
Search Results:
MAX() function
The MAX() function can find the maximum value of a field in a table.
Examples:
select max(score) from info;
Search Results:
MIN() function
The MIN() function finds the minimum value of a field in a table.
Examples:
select min(score) from info;
Search Results:
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.