, "kWh del"
, "kWh rec"
, "kWh del-rec"
FROM --(*vendor(PML),product(LogServer) EgyDmd Log@ALI.7600 *)--
WHERE (timestamp <= today_12AM()
timestamp >= yesterday())
ORDER BY timestamp DESC
-- SQL generated with ION Enterprise version 5.5 build 318
What operation should i use to get the total energy consumed yesterday. I am querying it from a remote meters database.The above operation is giving me energy consumed every 15min for the whole day.But i want to see the total energy consumed .
Please help!!!Its urgent......I am not a SQL guru but more of a hardware guy.