实时警报通知:微信告警通知的重要性解析
700
2022-10-12
华为GaussDB T IF(cond,exp1,exp2)
IF
语法:
IF(cond,exp1,exp2)
功能:计算条件cond,如果条件为真,则返回exp1,否则返回exp2。
示例:
--删除同名表staffS_xian。DROP TABLE IF EXISTS staffS_xian;--创建表staffS_xian。CREATE TABLE staffS_xian( staff_ID NUMBER(6) not null, NAME VARCHAR2(20), EMAIL VARCHAR2(25), PHONE_NUMBER VARCHAR2(20), HIRE_DATE DATE, employment_ID VARCHAR2(10), SALARY NUMBER(8,2), MANAGER_ID NUMBER(6), section_ID NUMBER(4));--向表staffS_xian中加入记录1。INSERT INTO staffS_xian (staff_ID, NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, employment_ID, SALARY, MANAGER_ID, section_ID)values (198, '王莹', 'wangying@126.com', '18095605632', to_date('21-06-1999', 'dd-mm-yyyy'), 'SH_CLERK', NULL, 124, 50);--向表staffS_xian中加入记录2。INSERT INTO staffS_xian (staff_ID, NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, employment_ID, SALARY, MANAGER_ID, section_ID)values (199, '何开平', 'hekaipng02@126.com', '18095605532', to_date('13-01-2000', 'dd-mm-yyyy'), 'SH_CLERK', 2600.00, 124, 50);--向表staffS_xian中加入记录3。INSERT INTO staffS_xian (staff_ID, NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, employment_ID, SALARY, MANAGER_ID, section_ID)values (200, '李瑞', 'lirui03@126.com', '18095565632', to_date('17-09-1987', 'dd-mm-yyyy'), 'AD_ASST', 4400.00, 101, 10);--向表staffS_xian中加入记录4。INSERT INTO staffS_xian (staff_ID, NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, employment_ID, SALARY, MANAGER_ID, section_ID)values (206, '李锐云', 'liruiyun03@126.com', '18095565892', to_date('17-09-1988', 'dd-mm-yyyy'), 'AD_ASST', 3900.00, 101, 10);--返回员工编号和工资列表,工资如果为NULL则返回secret。SELECT staff_ID, IF(SALARY < 4000, SALARY, 'secret') ""SALARY"" FROM staffS_xian WHERE staff_ID IS NOT NULL ORDER BY staff_ID;STAFF_ID SALARY---------------------------------------- ----------------------------------------------------198 secret199 2600200 secret206 39004 rows fetched.
发表评论
暂时没有评论,来抢沙发吧~