asked on UPDATE SQL statement
Hello friends,
I want to update all F (female) and M (Male) values (change all F values to M and vice versa) as per below table.
Id >> Name >> Sex >> Salary
1 >> A >> M >> 6000
2 >> B >> F >> 3500
3 >> C >> M >> 8500
4 >> D >> F >> 600
How should I write the query to update the values?
I want to update all F (female) and M (Male) values (change all F values to M and vice versa) as per below table.
Id >> Name >> Sex >> Salary
1 >> A >> M >> 6000
2 >> B >> F >> 3500
3 >> C >> M >> 8500
4 >> D >> F >> 600
How should I write the query to update the values?
Microsoft SQL ServerDatabases
Last Comment
Ajit Khodke
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Fixed..
Thanks Jim and bbao for great solution.
Thanks Jim and bbao for great solution.
Ajit Khodke - Let us know if these solutions met your needs.