MYSQL ==>
SELECT @i:=@i+1 as idx , `sk_water`.`dates` as dates,
`sk_water`.`forebay` as forebay,
sum(`sk_water`.`releases`) as sumrel,
`sk_water`.`nextday_rel_plan` as nowplan,
(sum(`sk_water`.`u1_energy`)+
sum(`sk_water`.`u2_energy`)+
sum(`sk_water`.`u3_energy`)+
sum(`sk_water`.`u4_energy`)) as engr
FROM (SELECT @i:=0) AS _init
join`sk_water`
WHERE (year(`sk_water`.`dates`) BETWEEN
(
SELECT max(year(`sk_water`.`dates`)-1)
FROM `sk_water`
) AND (
SELECT max(year(`sk_water`.`dates`))
FROM `sk_water`)
)
group by dates
ไม่มีความคิดเห็น:
แสดงความคิดเห็น