Group by

1.未用group by

SELECT category FROM tb_item;

 

2.使用group by 

SELECT category FROM tb_item GROUP BY category;

 

3.按条件分组查询

 SELECT category FROM tb_item WHERE brand='三星' GROUP BY category;