81,091
社区成员
发帖
与我相关
我的任务
分享
SELECT NVL(F_PHONE,'-1') F_PHONE FROM T_ACTIVITY GROUP BY F_PHONE HAVING COUNT(*) >=3
-- Oracle转换语法:
nvl(“字段名”,’转换后的值’);-- //字段名是双引号,转换后的值是单引号
-- 使用用例:
SELECT USERNAME FROM B_USER;
SELECT nvl("USERNAME",'改变后的值') as username FROM B_USER;
SELECT Nvl(F_PHONE, '-1')F_PHONE
FROM T_ACTIVITY
GROUP BY Nvl(F_PHONE, '-1')
HAVING Count(F_PHONE) >= 3