该函数在 SnowFlake, MaxCompute, DataBricks, Teradata, StarRocks 等分析数据库均支持, 常用来通过窗口函数过滤数据简化 SQL
函数语法参考:
CSDN
https://blog.csdn.net/m0_75176907/article/details/131866054
https://blog.csdn.net/wsdc0521/article/details/133687841
SnowFlake
https://docs.snowflake.com/en/sql-reference/constructs/qualify
DataBricks
https://learn.microsoft.com/zh-cn/azure/databricks/sql/language-manual/sql-ref-syntax-qry-select-qualify
Teradata
https://docs.teradata.com/r/Enterprise_IntelliFlex_VMware/SQL-Data-Manipulation-Language/SELECT-Statements/QUALIFY-Clause
MaxCompute
https://help.aliyun.com/zh/maxcompute/user-guide/qualify
StarRocks
https://docs.starrocks.io/zh/docs/sql-reference/sql-functions/Window_function/#%E4%BD%BF%E7%94%A8-qualify-%E7%AA%97%E5%8F%A3%E5%87%BD%E6%95%B0