Castamir
BANNED
- Sep 4, 2019
- 1,200
- 1,058
If you can handle a data set for a medical students website like the above, please dm. In return, I will improve your rankings by at least 10 spots in 5 days or less.How do you query a specific value from an Sql column containing multiple values, separated by comma?
Example
Let the table below represent a sql database with two columns named student and results. Results column contain two comma separated values. How can I select the "percentage" in an an Sql query?
Student | Results
---
Student 1| "marks": 12, "percentage"=2
Student 2 |"marks": 32, "percentage"=5
Student 3 |"marks": 52, "percentage"=9