MSCEWI3022

Siblings keyword removed from the order by clause because Snowflake does not support it.

Severity

Low

Description

SIBLINGS keyword was removed because is not supported in Snowflake.

Example Code

Input Code:

SELECT RANK() OVER (PARTITION BY USER_NAME ORDER SIBLINGS BY SALARY ASC NULLS FIRST, COMMISSION DESC NULLS LAST) FROM EMPLOYEES;

Output Code:

SELECT RANK() OVER (PARTITION BY USER_NAME ORDER BY SALARY ASC NULLS FIRST, COMMISSION DESC NULLS LAST) /*** MSC-WARNING - MSCEWI3022 - SIBLINGS KEYWORD REMOVED FROM ORDER BY CLAUSE BECAUSE SNOWFLAKE DOES NOT SUPPORT IT ***/ FROM PUBLIC.EMPLOYEES;

Recommendations

Last updated