Given a table SALARIES, such as the one below, that has m = male and f = female values. Swap all f and m values (i.e., change al | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Given a table SALARIES, such as the one below, that has m = male and f = female values. Swap all f and m values (i.e., change al

Id Name Sex Salary 1 A m 2500 2 B f 1500 3 C m 5500 4 D f 500

challenge
21st Dec 2016, 5:24 AM
Akwin Lopez
Akwin Lopez - avatar
1 Answer
0
UPDATE SALARIES SET sex = CASE sex WHEN 'm' THEN 'f' ELSE 'm' END
21st Dec 2016, 5:24 AM
Akwin Lopez
Akwin Lopez - avatar

Often have questions like this?

Learn more efficiently, for free:

See all courses
Hot today
Isogram Detector
2 Votes
Popsicle program
1 Votes
Need suggestions what improvements can I do in it
3 Votes
[SOLVED] Why 'null >= 0' is TRUE?
3 Votes
pls how do I write comments in code
0 Votes
R programming
2 Votes
What is the generally preferred way of assigning values in Python?
1 Votes
I want you to help me guys
0 Votes
How to add shadow on text
0 Votes
Hello
0 Votes