先建立临时表再查询

来源:互联网 发布:alfred mac app store 编辑:程序博客网 时间:2024/05/22 12:33
with AAA(ENODEB_ID,EARFCN)as (  select distinct A.ENODEB_ID,A.EARFCN  from tbcell as A, tbCell as B  where A.ENODEB_ID=B.ENODEB_ID and (A.longitude<>B.longitude or A.latitude<>B.latitude) and A.EARFCN=B.EARFCN )select *from tbcellwhere tbcell.ENODEB_ID in (select AAA.ENODEB_ID from AAA) and EARFCN=38400
0 0