SQL GROUP BY 語(yǔ)句
sql group by 語(yǔ)句
group by 語(yǔ)句用于結(jié)合聚合函數(shù)，根據(jù)一個(gè)或多個(gè)列對(duì)結(jié)果集進(jìn)行分組。
1. group by 語(yǔ)法
select column_name, aggregate_function(column_name)
from table_name
where column_name operator value
group by column_name;
from table_name
where column_name operator value
group by column_name;
學(xué)習(xí)SQL