Do you mean order of null value (column a) is wrong?
Use NULLS FIRST/LAST to order null values.
On Jan 2, 2025 at 18:19 +0800, 谭忠涛 <zhongtao.tan@seaboxdata.com>, wrote:
Case: create table t1(a int, b int); insert into t1 values(1,1),(1,2); select a,b,sum(10) as s from t1 where a = 1 group by rollup(a,b) order by a, s desc;
