Query to find occurrence count of a character in a column of string datatype

• Use the function LENGTH to get the length of the string

• Use the function REPLACE to replace all characters except the one you...read more

Select len(city)-len(replace(city, 'a', '')) from tablename;