掉了薪水的逆排序select name, category, salary where category = 'permanent' order by salary desc union all select name, category, salary where category = 'contract' order by salary desc