您现在的位置是:首页 > 电脑 > 

oracle insert into select写法

2025-07-18 00:16:03
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组装电脑配置单推荐报价格

本文地址:http://www.dnpztj.cn/diannao/549527.html

相关标签:无
上传时间: 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