题目:
语句:
select name,population,area from World where area>3000000 or population>25000000
交换工资:
语句:
Update salary
set
sex=(case when sex="m" then "f" else "m" END);
题目:
语句:
select name,population,area from World where area>3000000 or population>25000000
交换工资:
语句:
Update salary
set
sex=(case when sex="m" then "f" else "m" END);