oracle insert into select写法
ISERT ITO T_MOITOR_USER_IFO (
METER_O,
COSUMER_O,
USER_IFO,
COURT_ID
)
select * from
(
select
distinct
METER_O,COSUMER_O, wy as USER_
ISERT ITO T_MOITOR_USER_IFO (
METER_O,
COSUMER_O,
USER_IFO,
COURT_ID
)
select * from
(
select
distinct
METER_O,COSUMER_O, wy as USER_IFO,EPU_COURT as COURT_ID from T_METER
where
C_DISTRICTBCDID in
(
select
DISTICT
DISTRICTBCDID
from QX_SGMTUSR_DTL
where RECORDDATE=210917
and SEGMETID = 6
)
and C_ADDRESSID in
(
select
DISTICT
ADDRESSID
from QX_SGMTUSR_DTL
where RECORDDATE=210917
and SEGMETID = 6
)
and C_CHAELID in
(
select
DISTICT
CHAELID
from QX_SGMTUSR_DTL
where RECORDDATE=210917
and SEGMETID = 6
)
)
where rownum <= 100
#感谢您对电脑配置推荐网 - 最新i3 i5 i7组装电脑配置单推荐报价格的认可,转载请说明来源于"电脑配置推荐网 - 最新i3 i5 i7组装电脑配置单推荐报价格
上传时间: 2023-06-29 02:05:36
推荐阅读
留言与评论(共有 5 条评论) |
本站网友 网易微博 | 21分钟前 发表 |
EPU_COURT as COURT_ID from T_METER where C_DISTRICTBCDID in ( select DISTICT DISTRICTBCDID from QX_SGMTUSR_DTL where RECORDDATE=210917 and SEGMETID = 6 ) and C_ADDRESSID in ( select DISTICT ADDRESSID from QX_SGMTUSR_DTL where RECORDDATE=210917 and SEGMETID = 6 ) and C_CHAELID in ( select DISTICT CHAELID from QX_SGMTUSR_DTL where RECORDDATE=210917 and SEGMETID = 6 ) ) where rownum <= 100 | |
本站网友 碧桂园凤凰城南京 | 25分钟前 发表 |
COURT_ID ) select * from ( select distinct METER_O | |
本站网友 易语言源码大全 | 15分钟前 发表 |
EPU_COURT as COURT_ID from T_METER where C_DISTRICTBCDID in ( select DISTICT DISTRICTBCDID from QX_SGMTUSR_DTL where RECORDDATE=210917 and SEGMETID = 6 ) and C_ADDRESSID in ( select DISTICT ADDRESSID from QX_SGMTUSR_DTL where RECORDDATE=210917 and SEGMETID = 6 ) and C_CHAELID in ( select DISTICT CHAELID from QX_SGMTUSR_DTL where RECORDDATE=210917 and SEGMETID = 6 ) ) where rownum <= 100 | |
本站网友 种子哈希 | 30分钟前 发表 |
COSUMER_O |