Can anyone explain how to split comma separated values in the SQL query?
We can use STRING_SPLIT() function to split the values on a specific separator. Here is an example to split comma separated values in SQL.
Select color from STRING_SPLIT( ‘red, blue, yellow’, ‘,’);
I advise registering for this SQL certification program by Intellipaat to learn SQL.