请问group by 后的字段能否不区分大小写

Question

SQL> select * from a;AAA              BBB       CCC
---------- --------- ---------
101                1
102                2
103                3
103               43
102                5
aaa                6         6
AAA                7         7已选择7行。SQL> select a,sum(bbb) from (select upper(aaa) a,bbb from a) group by a;A           SUM(BBB)
---------- ---------
101                1
102                7
103               46
AAA               13

Answer 1

SQL> select * from t;A          B
-- ---------
cc        15
CC        15
CC       120
cc        20
dd        20SQL>select upper(a),sum(b) from t group by upper(a)
UP    SUM(B)
-- ---------
CC       170
DD        20

Answer 2

select a,sum(bbb) from (select aaa a,bbb from a) group by a