1、查询表里某字段出现的次数并排序
例如:门店表
一个商户下有多个门店,查询商户下关联的门店数量,并排序
select shop_id ,shop_cust_id ,count() from shop_info si
group by shop_cust_id
order by count() desc;
sql-查询
最新推荐文章于 2024-10-04 22:00:00 发布
1、查询表里某字段出现的次数并排序
例如:门店表
一个商户下有多个门店,查询商户下关联的门店数量,并排序
select shop_id ,shop_cust_id ,count() from shop_info si
group by shop_cust_id
order by count() desc;