select a.test,b.* from (select @y:=@y+1 as test,a.* from (select * from resourcecenter.cm_identify_relation a group by a.issue_party ) a,(select @y:=0) d order by issue_party) a, resourcecenter.cm_identify_relation b where a.issue_party=b.issue_party order by b.issue_party
mysql 按字段a排序 并编序列号,字段a值相同的编号相同
最新推荐文章于 2023-03-17 16:03:42 发布