1. Write a query to find the Occurrence count of a character in a column of string datatype? Ex : Column : City, with values : Bangalore, Chennai, Hyderabad . Find how many times A is repeated in these 3 values.

Question

Accepted Answer

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 want to count
Use the function LENGTH again to get the count of the character

Accepted Answer

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

1. Write a query to find the Occurrence count of a character in a column of string datatype? Ex : Column : City, with values : Bangalore, Chennai, Hyderabad . Find how many times A is repeated in these 3 values.

Top Zenoti Data Migration Engineer interview questions & answers