selectcount(vend_ic)from products where vend_id>10001;
创建分组
selectcount(prod_ic),vend_id,vend_price from products groupby vend_price;// group by 分组数据
过滤分组
selectcount(vend_ic),vend_id from products where vend_id>10001groupby vend_id;//where vend_id>10001selectcount(vend_ic),vend_id from products groupby vend_id having(conunt(vend_ic))>=5;selectcount(vend_ic),vend_id from products groupby vend_id having(count(vend_ic))between3and10;
分组和排序
selectcount(vend_ic),vend_id from products groupby vend_id orderbycount(vend_ic)desc;// 降序
select子句顺序
selectcount(vend_ic),vend_id from products where vend_id>1000groupby vend_id havingcount(vend_ic)>1orderbycount(vend_ic)desc;// 降序