情况如下:
select * from users;
........
607 rows selected
SQL> select count(distinct db_user) from users;
COUNT(DISTINCTDB_USER)
----------------------
607
后来仔细查看users,发现db_user字段中包含少许的含有数字的值,如‘a1bbc2’,'a2bbc2'。
怎样在转化成大写的时候,将数字也一同带过来?select
select * from users;
........
607 rows selected
SQL> select count(distinct db_user) from users;
COUNT(DISTINCTDB_USER)
----------------------
607
后来仔细查看users,发现db_user字段中包含少许的含有数字的值,如‘a1bbc2’,'a2bbc2'。
怎样在转化成大写的时候,将数字也一同带过来?select
看下下面sql的结果
select upper(db_user), count(*)
from users
having count(*) > 1
group by upper(db_user);
from users
group by upper(db_user)