英 [ɡru:p bai]? ?美 [ɡrup ba?]??
[計(jì)][WIN]分組依據(jù)
mysql GROUP BY語句 語法
作用:用于結(jié)合合計(jì)函數(shù),根據(jù)一個(gè)或多個(gè)列對結(jié)果集進(jìn)行分組。
語法:SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name operator value GROUP BY column_name