![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
pengruikeji
这个作者很懒,什么都没留下…
展开
-
一段复合查询的sql语句备份 排序 group
select * from brands b join (select brand_id,count(*) as product_amount from products where id in (#{product_id_array.join(',')}) group by b原创 2011-07-27 15:48:22 · 1241 阅读 · 0 评论 -
一段复合查询的sql语句备份 排序 group
select * from brands b join (select brand_id,count(*) as product_amount from products where id in (#{product_id_array.join(',')}) group by brand_id order by count(*) desc) as bc where b.id = bc.brand_...原创 2011-07-27 15:51:32 · 99 阅读 · 0 评论