备份表
--创建表结构
create table dwd_wind_fact_downtime_20210709 as select * from dwd_wind_fact_downtime where 1=2;
--备份指定数据
insert into dwd_wind_fact_downtime_20210709 select * from dwd_wind_fact_downtime -- Where [条件1,条件2]
时间线上最大间隔时间(pgsql)
with t1 as(
SELECT
--r.region_name,
--wf.site_name,
--wt.feedline_name,
--wt.wtg_type,
-- wt.wtg_name,
-- wt.on_grid_date,
wtsr.start_time,
wtsr.end_time,
--wtsr.description,
COALESCE ( wt.wtg_id_yj, wt.wtg_id ) AS wtg_id,
--wt.feedline_id,
wt.brand,
ROW_NUMBER() OVER (PARTITION BY wt.brand ORDER BY wtsr.start_time)RowNum
FROM
dim_wind_device wt
LEFT JOIN (
SELECT