1.获取ID
SELECTnewid()2.将UUID值中的-替换
SELECTREPLACE(newid(),'-','')3.获取ID并转小写
SELECTLOWER(REPLACE(newid(),'-','')) AS UUID
4.获取ID并转大写
SELECTUPPER(REPLACE(newid(),'-','')) AS UUID
结合CSAE…WHEN的使用
1.使用方法: 基本一样
(CASE LEADING_ROLE WHEN '2' THEN EXCELLENT_PROJECT *1.1 ELSE EXCELLENT_PROJECT *1 END) EXCELLENT_PROJECT
(CASE WHEN AAA.LEADING_ROLE IS NULL THEN BBB.LEADING_ROLE ELSE AAA.LEADING_ROLE END) LEADING_ROLE
2. 判断表中UUID是否为null(CASE WHEN ARW.UUID IS NULL THENLOWER(REPLACE(newid(),'-','')) ELSE '显示原UUID' END) AS UUID
GROUP BY 分组拼接字段数据
1. 用法:SELECTto_char(wm_concat(UUID))2.真实使用: select to_char(wm_concat( 当前UUID)),主表UUID from 表明 where 条件 group by 主表UUID // 结果: (主表列)主表UUID ,(当前UUID列)当前UUID,当前UUID,当前UUID