How to normalize the data by splitting the values in a column into rows in MYSQL? What function to use?
I had to normalize data first and then move on with sub-questions by writing SQL queries.
This was asked in an interview- How to normalize the data by splitting the values in a column into rows in MYSQL? What function to use?
So basically, I had one interview which went well but then I was given a task where I had to normalize the data first and then should move on with the sub-questions by writing SQL queries. I got stuck while doing the data normalization itself in MYSQL, but my other(sub-question) queries were correct. If anyone knows how to do this please do help and if you could explain the process will be helpful. I am just getting my hands on in SQL queries and questions like these are little harder for me even though the theory part is clear.