How to swap columns value in a SQL table

Jak

908 Points

132 Posts

Hi,

I have table xyz as:

C1	C2
1	2
3	4

I want result something like that

C1	C2
2	4
1	3

How can achieve this.

Thanks.

sql query database

Views: 9162
Total Answered: 0
Total Marked As Answer: 0
Posted On: 15-Dec-2015 06:10

Share:

Answers

Discussion

SignalR for real-time web functionality

MVC Design pattern

What is the current status of artif...

Modern Web Development using ASP.NE...

Is Programming an Art or a Science?

Blazor is a UI Web framework for bu...

Blog

Migrating ASP.NET Core 8.0 to 9.0 – A Comprehensive Guide

Semantic Kernel vs AI library in .NET

How to update Status on NiceOneCode.com?

What is Generative AI (Generative Artificial Intelligence)?

Active User (9)

Log In to Chat