select之group by

select column_name, aggregate_name(column_name)

from table_name

where column_name operator value

group by column_name;

 

理论上是比较耗查询时间。