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

[hellobb]

如题

[bzszp]

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

['Alan]

SQL> select * from t;

A B
-- ---------
cc 15
CC 15
CC 120
cc 20
dd 20

SQL>select upper(a),sum(b) from t group by upper(a)


UP SUM(B)
-- ---------
CC 170
DD 20

[洪十二]

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