hi iwant to reform my data like below: my table is sarah 254 65487 john 85 and i want this: sarah 254 sarah 65487 john 85

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.

hi thank you for attention i have a big database and one of columns is like this sample and i want to seprate it

Answers

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

saman lahoti

624

iwant to reform my data like below:

my table is

sarah

254

65487

john

and i want this:

sarah	254
sarah	65487
john	85

Answers (2)

Next Recommended Forum

sql related Query Please help

when Build Dynamic query Error display converting data type varchar to

Forum Statistics

Please welcome our newest member prajna varshini.
3,090,019 users have contributed to 147,411 threads and 483,554
In the past 24 hours, we have 3 new threads, 13 new posts, and 85 new users.
In last week, the most popular thread is 'what are libraries are there in python for Schedule'.

Upcoming Events

View all

Get Web3 Ready: Dive into Blockchain with C# Corner
Vibe Coding Bootcamp
Software Architecture Conference - 2025