题解|查找字符串中逗号次数(length, replace)
查找字符串中逗号出现的次数
https://www.nowcoder.com/practice/e3870bd5d6744109a902db43c105bd50
SELECT id, LENGTH(string) - LENGTH(replace(string,',', '')) AS cnt FROM strings
查找字符串中逗号出现的次数
https://www.nowcoder.com/practice/e3870bd5d6744109a902db43c105bd50
SELECT id, LENGTH(string) - LENGTH(replace(string,',', '')) AS cnt FROM strings
相关推荐
notbeentak...:就抓,嗯抓,开不开匿名都要抓,一点坏事不让说,就对公司顶礼膜拜佩服的五体投地就对了