Oracle rank()与dense_rank()区别

1. Oracle RANK():

• Oracle RANK() function is used to rank rows within a result set, based on a specified column or expression.
• The RANK() function assigns a unique rank to each row in the result set, where rows with the same value in the specified column or expression are assigned the same rank.
• If two rows have the same value in the specified column or expression, they will be assigned the same rank, and the next rank will be skipped.

2. Oracle DENSE_RANK():

• Oracle DENSE_RANK() function is also used to rank rows within a result set, based on a specified column or expression.
• The DENSE_RANK() function assigns a unique rank to each row in the result set, where rows with the same value in the specified column or expression are assigned the same rank.
• Unlike the RANK() function, the DENSE_RANK() function does not skip ranks if two or more rows have the same value in the specified column or expression. It assigns consecutive ranks to all rows.

In summary, the main difference between the RANK() and DENSE_RANK() functions in Oracle is how they handle ties. RANK() may skip ranks if there are ties, while DENSE_RANK() does not skip ranks and assigns consecutive ranks to all rows.

以上就是关于“Oracle rank()与dense_rank()区别”的相关介绍，筋斗云是国内较早的云主机应用的服务商，拥有10余年行业经验，提供丰富的云服务器、租用服务器等相关产品服务。云服务器资源弹性伸缩，主机vCPU、内存性能强悍、超高I/O速度、故障秒级恢复；电子化备案，提交快速，专业团队7×24小时服务支持！

简单好用、高性价比云服务器租用链接：https://www.jindouyun.cn/product/cvm