oceanbase
19 строк · 560.0 Байт
1--disable_query_log
2set @@session.explicit_defaults_for_timestamp=off;
3--enable_query_log
4#owner: bin.lb
5#owner group: sql1
6#tags: group_by
7#description:
8
9--disable_warnings
10drop table if exists test;
11--enable_warnings
12create table test(a int primary key,b int,c int);
13insert into test values(1,4,null);
14insert into test values(3,3,null);
15insert into test values(4,3,null);
16select avg(distinct(a)),avg(a),avg(b) from test;
17select avg(distinct(b)),avg(b),avg(c) from test;
18select avg(c),avg(b),avg(distinct(b)) from test;
19select avg(c),avg(b),avg(b) from test;
20