如何从两个计算结果中选择较小的值 - ClickHouse SQL 指南

你可以使用 CASE 语句来选择较小的值。以下是一个例子：

SELECT toStartOfDay(toDateTime(Ds)) AS datetime_day_Ds, AppIdentifier AS AppIdentifier, sum(AvgDeviceTime) AS index_avgdevicetime_0, CASE WHEN sum(AvgDeviceTime) <= sum(AvgDeviceTime) / count() THEN sum(AvgDeviceTime) ELSE sum(AvgDeviceTime) / count() END AS index_avgdevicetime_0 FROM 表名 GROUP BY datetime_day_Ds, AppIdentifier