The Resource Group Interview Question: SQL query to count the occurrences of character 'R' in a string.

Notifications

The Resource Group

SQL query to count the occurrences of character 'R' in a string.

Anonymous

Oct 6, 2014

Didn't have the answer

Anonymous

Jun 15, 2021

I posted the answer using a query (recursive by using CTE of SQL SERVER) Cell: 03343965257

Anonymous

Sep 1, 2022

Select round(length(desc) length(replace(desc,”R”,””)))/length(“R”)) as count_r From table