xiexie1357的专栏

620. 有趣的电影 select * from cinema where description != "boring" and mod(id, 2) = 1 order by rating DESC //奇数判断：mod(id, 2)； 排序 order by 175. 组合两个表 # Write your MySQL query statement below selec...

627. 交换工资 update salary s set s.sex = case s.sex when 'm' then 'f' #如果是m,改成f else 'm' # 否则还是m end; 26. 换座位 select (case when mod(i...