select * from dd_circle_shop_meta_categoty d, dd_circle_shop_meta_categoty f where d.second_cname=f.second_cname and d.first_cname != f. first_cname group by d.first_cname,d.second_cname
查询表的second_cname相同,但first_cname不同的数据,并按这两个字段分组
select * from dd_circle_shop_meta_categoty d, dd_circle_shop_meta_categoty f where d.second_cname=f.second_cname and d.first_cname != f. first_cname group by d.first_cname,d.second_cname
查询表的second_cname相同,但first_cname不同的数据,并按这两个字段分组