Red informatica CEAZA CEAZA CEAZA-Met  
Slideshow Image 1 Slideshow Image 1 Slideshow Image 1 Slideshow Image 1
  Herramientas


Ver preferenciasPreferencias
de Usuario
Sensores Disponibles
 
   

   
Error in SQL query: ERROR: syntax error at or near ")" LINE 1: ...ax) as si_max,sum(cant_horas) as cant_horas from () as si g... ^ Query:select 'HDCTA' as s_cod,min (fecha) as fecha,min(si_min) as si_min,avg(si_prom) as si_prom,max(si_max) as si_max,avg(data_pc) as data_pc from (select *,('HDCTA') as s_cod,(coalesce(cant_horas*(24/24),0)*100/cant_total_horas) as data_pc from (select min(ch_fechahora) as fecha ,count(*) as cant_total_horas from calendario_hora where ch_fechahora>='2019-01-01 00:00:00' and ch_fechahora<='2019-12-31 23:59:59' group by extract(year from ch_fechahora),extract(month from ch_fechahora) order by extract(year from ch_fechahora),extract(month from ch_fechahora)) as qhora1 left join (select min(si_fecha_gmt4) as si_fecha_gmt4,min(si_min) as si_min,avg(si_min) as si_mindia_avg,avg(si_prom) as si_prom,avg(si_min) as si_maxdia_avg,max(si_max) as si_max,sum(cant_horas) as cant_horas from () as si group by extract(year from si_fecha_gmt4),extract(month from si_fecha_gmt4)) as qhora2 on extract(year from fecha)=extract(year from si_fecha_gmt4) and extract(month from fecha)=extract(month from si_fecha_gmt4) order by fecha) as ws group by extract (hour from fecha) order by extract (hour from fecha)