oracle insert into select写法

原创已于 2023-02-14 14:59:27 修改 · 1.8w 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #sql

于 2021-09-17 15:10:49 首次发布

SQL 同时被 3 个专栏收录

13 篇文章

订阅专栏

Oracle

8 篇文章

订阅专栏

数据库

1 篇文章

订阅专栏

本文介绍了一种通过SQL语句批量插入监控用户信息的方法。该方法利用了子查询结合DISTINCT关键字来确保数据的唯一性，并限制了每次插入的数据量不超过100条记录。所涉及的数据表包括T_MONITOR_USER_INFO、T_METER等，条件筛选基于QX_SGMTUSR_DTL表中特定日期和段ID的数据。



INSERT INTO T_MONITOR_USER_INFO (
METER_NO,
CONSUMER_NO,
USER_INFO,
COURT_ID
)


select * from
(
select 
distinct
METER_NO,CONSUMER_NO,'wy' as USER_INFO,EPU_COURT as COURT_ID from T_METER 
where 
C_DISTRICTBCDID in 
(
select 
DISTINCT
DISTRICTBCDID
from QX_SGMTUSR_DTL 
where RECORDDATE=210917
and SEGMENTID = 36


)
and C_ADDRESSID in 
(
select 
DISTINCT
ADDRESSID
from QX_SGMTUSR_DTL 
where RECORDDATE=210917
and SEGMENTID = 36
)
and C_CHANNELID in 
(
select 
DISTINCT
CHANNELID
from QX_SGMTUSR_DTL 
where RECORDDATE=210917
and SEGMENTID = 36
)
)
where rownum <= 100