今天上传了Teradata的递归sql,也把抽样的sql一起贴出来。
DATABASE PCDE2;
SELECT REGION_CODE,CITY_CODE,CITY_DESC
FROM TB_CDE_LOC_CITY
GROUP BY 1
QUALIFY RANK(CITY_CODE) < 11;
今天上传了Teradata的递归sql,也把抽样的sql一起贴出来。
DATABASE PCDE2;
SELECT REGION_CODE,CITY_CODE,CITY_DESC
FROM TB_CDE_LOC_CITY
GROUP BY 1
QUALIFY RANK(CITY_CODE) < 11;