1show status like '%window%'; 2Variable_name Value 3Feature_window_functions 0 4create table t1 (a int, b int); 5insert into t1 values (1, 10), (2, 20), (3, 30); 6select a, b, rank() over (order by a) from t1; 7a b rank() over (order by a) 81 10 1 92 20 2 103 30 3 11show status like '%window%'; 12Variable_name Value 13Feature_window_functions 1 14select a, b, rank() over (order by a), sum(a) over (order by a) from t1; 15a b rank() over (order by a) sum(a) over (order by a) 161 10 1 1 172 20 2 3 183 30 3 6 19show status like '%window%'; 20Variable_name Value 21Feature_window_functions 2 22select t_a.r1, t_b.r2 23from (select a, b, rank() over (order by a) as r1 from t1) t_a, 24(select a, b, row_number() over (order by a) as r2 from t1) t_b; 25r1 r2 261 1 271 2 281 3 292 1 302 2 312 3 323 1 333 2 343 3 35show status like '%window%'; 36Variable_name Value 37Feature_window_functions 4 38drop table t1; 39