SQL查询语句优化
select top 5 peopleName,peopleSalary, peopleSex
from people where peopleSex ='男'order by peopleSalary desc
select top 5 peopleName,peopleSalary, peopleSex
from people where peopleSex='女' order by peopleSalary desc
查询工资最高的5位男员工 查询工资最高的5位女员工 如何合并成一条SQL语句啊？
展开
收起
4
条回答
写回答
写回答
-
SELECT * FROM ( SELECT ROW_NUMBER() OVER (PARTITION BY peopleSex ORDER BY peopleSalary DESC) rowid, peopleName,peopleSalary, peopleSex FROM people ) TT WHERE TT.rowid <= 5;
2022-06-29 15:59:46赞同 展开评论 打赏 -
select top 5 * from ..... where .... union select top 5 * from ..... where ....
2022-03-02 08:49:38赞同 展开评论 打赏 -
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
相关问答
