select eid,cid,(select count(*) from table_mydata B where B.eid = A.eid) N,
(select count(*)+1 from table_mydata C where C.eid = A.eid and C.cid < A.cid) n
from table_mydata A group by eid, cid order by cid
(select count(*)+1 from table_mydata C where C.eid = A.eid and C.cid < A.cid) n
from table_mydata A group by eid, cid order by cid
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货