select convert(varchar(10),时间,120) 年月日,
max(水位) as 最高水位,
max(闸位) as 最高闸位,
avg(流量) as 平均流量,
sum(每分钟水量) as 当日用水量
from ZK_Real_BG
group by convert(varchar(10),时间,120)
max(水位) as 最高水位,
max(闸位) as 最高闸位,
avg(流量) as 平均流量,
sum(每分钟水量) as 当日用水量
from ZK_Real_BG
group by convert(varchar(10),时间,120)
max(水位) as 最高水位,
max(闸位) as 最高闸位,
avg(流量) as 平均流量,
sum(每分钟水量) as 当日用水量
from ZK_Real_BG
group by convert(varchar(10),年月日,120)