数据仓库服务 GAUSSDB(DWS)-DML（Netezza）:ATTRIBUTE (应指定AS)

时间：2024-06-29 17:51:38

ATTRIBUTE (应指定AS)

Netezza语法

迁移后语法

       
            SELECT t1.etl_date, substr(t1.attribute,1,1) attribute
     , t1.cust_no, t1.branch_code
  FROM ( SELECT etl_date,attribute,cust_no,branch_code
           FROM tb_ntz_keyword_attribute
          WHERE etl_date = CURRENT_DATE ) t1;

       
            SELECT t1.etl_date, substr(t1.attribute,1,1) AS attribute
     , t1.cust_no, t1.branch_code
  FROM ( SELECT etl_date,attribute,cust_no,branch_code
           FROM tb_ntz_keyword_attribute
          WHERE etl_date = CURRENT_DATE ) t1;