sql分组函数使用(国外英语资料).docVIP

sql分组函数使用(国外英语资料) In real SQL applications, group aggregation is often required, and the query object is grouped by a certain condition and then aggregated for each group. GROUP BY clause creates the grouping Creating groups is implemented through the GROUP BY clause. Unlike the WHERE clause, the GROUP BY clause is used to generalize the information type to summarize the relevant data. Why use the GROUP BY clause to create groups? The following simple example illustrates this. Instance 17 queries for a single group If you want to query the average salary for all male teachers from the TEACHER table, the code is as follows: SELECT AVG (SAL) AS boyavg_sal FROM the TEACHER WHERE TSEX = man The results are shown in figure 8.18. Figure 8.18 shows the average salary for all male teachers in the TEACHER table What if the average salary for all female teachers is needed at the same time? Obviously, this method can only change the query condition in the WHERE clause and requery it. And if you want to in a query, get the query result at the same time, needs to be based on gender, all the data in the table, the grouping of the records that male teachers and female teachers groups, and analyze the two groups of data, namely, calculate the average wage (SAL). To do this, you need to use the grouping clause GROUP BY. Queries that include the GROUP BY clause are called composite queries. Syntax is as follows. SELECT column, SUM (column) FROM table GROUP BY column Note: the GROUP BY clause is grouped BY the data in column column, which means that rows with the same values are grouped. It is commonly used at the same time as the aggregation function. Of course, the SUM () function here can also be another aggregation function. All of the composite column (column) listed in the GROUP BY clause must be FROM the FROM clause is listed in the table, not according to the actual values, the result of the aggregation function or other expression to calculate the value of the line to the GRO