试试这个
select name, category, salary where category = 'permanent' order by salary
union all
select name, category, salary where category = 'contract' order by salary
union all
select name, category, salary where category = 'contract' order by salary
本帖共有 30 楼,当前显示第 5 楼,本文还有 N-1 层楼,要不你试试看:点击此处阅读更多 >>