select a.*
from (select name,fen,rq from table where rq=1) a,(select name,fen,rq from table where rq=2) b
where a.name=b.name and
and abs(a.fen-b.fen)=25
from (select name,fen,rq from table where rq=1) a,(select name,fen,rq from table where rq=2) b
where a.name=b.name and
and abs(a.fen-b.fen)=25
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货