17,377
社区成员
发帖
与我相关
我的任务
分享
create table customise4 as
SELECT 关口点全名,电能量类型,数据 FROM 表底
WHERE datetime BETWEEN
to_date('2015/01/06','yyyy/mm/dd')
AND to_date('2015/01/20','yyyy/mm/dd') and
(电能量类型='正向有功' or 电能量类型='反向有功')
GROUP BY 关口点全名,电能量类型,数据
HAVING COUNT(关口点全名)=(
To_date('2015/01/20 00:00:00' , 'yyyy/mm/dd hh24:mi:ss') -
To_date('2015/01/06 23:59:59' , 'yyyy/mm/dd hh24:mi:ss'))
HAVING COUNT(关口点全名)=15