Loading

How do you separate a single column in to two columns in SQL?

saman lahoti

6y797

hi

iwant to reform my data like below:

my table is

sarah

254

65487

john

85

and i want this:

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

saman lahoti6y ago
hi
thank you for attention

i have a big database and one of columns is like this sample and i want to seprate it
0
Vrushali Ghodke6y ago
Hi, can you please explain your issue in detail. In my opinion, you have to create two columns in one table and then insert data on that table as per the column name.
+1