题解 | #查询最低最高薪资差别大于2的用户#
查询投递最低最高薪资差别大于2的职位的投递用户user_id
https://www.nowcoder.com/practice/88b3cd0bde4141dfbfa79c3dec44fd9a
select user_id from `deliver_record_detail` t where ifnull(t.max_salary,0)-ifnull(t.min_salary,0)>2
查询投递最低最高薪资差别大于2的职位的投递用户user_id
https://www.nowcoder.com/practice/88b3cd0bde4141dfbfa79c3dec44fd9a
select user_id from `deliver_record_detail` t where ifnull(t.max_salary,0)-ifnull(t.min_salary,0)>2
相关推荐