Question: this is a sql issue I have a table that looks like like table-1 below. I want a querry that can turn it into table-2.

this is a sql issue
I have a table that looks like like table-1 below. I want a querry that can turn it into table-2. Please dont give me a querry where I have to use specifc names. my actual table is far too large and has too many diffrernt names for me to use a querey like that. all units in the column in my actual table have commas as well.
this is a sql issueI have a table that looks like like
table-1 below. I want a querry that can turn it into table-2.

Table-1 \begin{tabular}{|l|} \hline NAME \\ \hline Biden, Joe \\ \hline Trump, Donald \\ \hline Obama, Barack \\ \hline Bush, George \\ \hline \end{tabular} Table-2 \begin{tabular}{|l|} \hline NAME \\ \hline JOE BIDEN \\ DONALD TRUMP \\ BARACK OBAMA \\ \hline GEORGE BUSH \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!