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

6 Oct 2014

Didn't have the answer

Anonymous

15 Jun 2021

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

Anonymous

1 Sept 2022

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