摘要:
1:SELECT ID, SID FROM Test WHERE ID ='001' 2:SELECT ID,LISTAGG(SID, ',') WITHIN GROUP (ORDER BY SID) AS SID_LIST FROM Test WHERE ID ='001' group by ID 阅读全文
摘要:
with tb1 as(select 1 a ,0 b) select ISNULL((a*1.0 / NULLIF(b,0)) ,0) AB from tb1 说明: a必须乘以1.0 否则 with tb1 as(select 1 a ,2 b) 还是0 NULLIF(b,0) ,是判断 b 是 阅读全文