# 题目:查找字符串'10,A,B' 中逗号','出现的次数cnt。 # 解析:本题考查了replace替换的用法,思路是:原字符串本身的长度 - 将,替换为空后的字符的长度, # 即得出出现,的次数; # replace: 替换 # length: 长度 SELECT (LENGTH("10,A,B") - LENGTH(REPLACE("10,A,B", ",","" ))) AS cnt