SQL语句实现按照分组划分优先级
SQL语句实现按照分组划分优先级
-------分组划分优先级 SELECT B.* FROM (SELECT A.color, A.P, row_number() over(partition by P order by color desc) rn FROM (SELECT 'red' AS color, '3' AS P FROM DUAL UNION SELECT 'red' AS color, '3' AS P FROM DUAL UNION SELECT 'black' AS color, '3' AS P FROM DUAL UNION SELECT 'yellow' AS color, '2' AS P FROM DUAL UNION SELECT 'green' AS color, '2' AS P FROM DUAL UNION SELECT 'blue' AS color, '1' AS P FROM DUAL) A) B WHERE rn < 2
结果截图:
本文来自博客园,作者:码农阿亮,转载请注明原文链接:https://www.cnblogs.com/wml-it/p/13650662.html
技术的发展日新月异,随着时间推移,无法保证本博客所有内容的正确性。如有误导,请大家见谅,欢迎评论区指正!
开源库地址,欢迎点亮:
GitHub:https://github.com/ITMingliang
Gitee: https://gitee.com/mingliang_it
GitLab: https://gitlab.com/ITMingliang
建群声明: 本着技术在于分享,方便大家交流学习的初心,特此建立【编程内功修炼交流群】,为大家答疑解惑。热烈欢迎各位爱交流学习的程序员进群,也希望进群的大佬能不吝分享自己遇到的技术问题和学习心得!进群方式:扫码关注公众号,后台回复【进群】。
![](https://images.cnblogs.com/cnblogs_com/wml-it/2196906/o_230823011905_wxgzhss.png)