先建立临时表再查询、从临时表查询

最新推荐文章于 2024-07-29 03:50:58 发布

谛听-

最新推荐文章于 2024-07-29 03:50:58 发布

阅读量3k

点赞数

分类专栏： Sql

本文链接：https://blog.csdn.net/u012319493/article/details/51539109

版权

Sql 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

先建立临时表再查询

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 tbcell
where tbcell.ENODEB_ID in (select AAA.ENODEB_ID from AAA) and EARFCN=38400

从临时表查询

            select a.GXID, a.GYID, a.ReceivedPowerdbm
            from 
            (select GXID, GYID, max(ReceivedPowerdbm) ReceivedPowerdbm 
            from tbGridPathloss  where GXID between 790 and 1050
            and GYID between 977 and 1317  group by gxid, gyid
            having max(ReceivedPowerdbm) > -130 ) as a(gxid, gyid, ReceivedPowerdbm)
            order by gxid, gyid