题解 |查询最低最高薪资差别大于2的投递用户user_id
查询投递最低最高薪资差别大于2的职位的投递用户user_id
https://www.nowcoder.com/practice/88b3cd0bde4141dfbfa79c3dec44fd9a
SELECT user_id
FROM deliver_record_detail
WHERE ifnull(max_salary,0)-ifnull(min_salary,0)>2
*注意有两条空数据需要排除
查询投递最低最高薪资差别大于2的职位的投递用户user_id
https://www.nowcoder.com/practice/88b3cd0bde4141dfbfa79c3dec44fd9a
SELECT user_id
FROM deliver_record_detail
WHERE ifnull(max_salary,0)-ifnull(min_salary,0)>2
*注意有两条空数据需要排除
相关推荐