How to swap columns value in a SQL table

Jak

Member

858 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: 8994
Total Answered: 0
Total Marked As Answer: 0
Posted On: 15-Dec-2015 06:10

Share:

Answers

Ayodhya Ram Mandir (अयोध्या राम मंदिर)

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

Steps to Manage SharePoint User Profiles Using Admin Centre

How to Show/Hide i.e. Toggle Password visibility using jQuery and JavaScript?

How do I add consent cookie component in Blazor?

Adding Azure Key Vault secrets in Azure Pipelines

Active User (3)

Log In to Chat