标签文章:#mysql-distinct#
-
Mysql 查询去除重复字段
selectt1.*,count(distinctname)fromtablet1leftjointable2t2ont2.t1_id=t1.idgroupbynameorderbyt2.order_columlimit0,1000
Nemo 2016.12.02 14:52 3618浏览 0回复
阅读更多
selectt1.*,count(distinctname)fromtablet1leftjointable2t2ont2.t1_id=t1.idgroupbynameorderbyt2.order_columlimit0,1000
Nemo 2016.12.02 14:52 3618浏览 0回复
阅读更多