您好,歡迎來(lái)到賦能網(wǎng)!

java教程單行函數(shù)之流程函數(shù)

賦能網(wǎng) 2023-06-11 284

流程函數(shù)

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

 

java教程單行函數(shù)之流程函數(shù)

java教程單行函數(shù)之流程函數(shù)

IF(value,t ,f) 如果value是真,返回t,否則返回f
IFNULL(value1, value2) 如果value1不為空,返回value1,否則返回value2
CASEWHEN 條件1 THEN result1WHEN 條件2 THEN result2….[ELSE resultn]END 相當(dāng)于Java的if…else if…
CASE exprWHEN 常量值1 THEN 值1WHEN 常量值1 THEN 值1….[ELSE 值n]END 相當(dāng)于Java的switch
SELECt ename ,CASEWHEN salary>=15000 THEN ‘高薪’WHEN salary>=10000 THEN ‘潛力股’WHEN salary>=8000 THEN ‘屌絲’ELSE ‘草根’ENDFROM t_employee;
SELECt oid,`status`, CASE `status`WHEN 1 THEN ‘未付款’WHEN 2 THEN ‘已付款’WHEN 3 THEN ‘已發(fā)貨’WHEN 4 THEN ‘確認(rèn)收貨’ELSE ‘無(wú)效訂單’ENDFROM t_order;

本文鏈接:

本文章“java教程單行函數(shù)之流程函數(shù)”已幫助 284 人

免責(zé)聲明:本信息由用戶發(fā)布,本站不承擔(dān)本信息引起的任何交易及知識(shí)產(chǎn)權(quán)侵權(quán)的法律責(zé)任!

本文由賦能網(wǎng) 整理發(fā)布。了解更多培訓(xùn)機(jī)構(gòu)》培訓(xùn)課程》學(xué)習(xí)資訊》課程優(yōu)惠》課程開班》學(xué)校地址等機(jī)構(gòu)信息,可以留下您的聯(lián)系方式,讓課程老師跟你詳細(xì)解答:
咨詢熱線:4008-569-579

如果本頁(yè)不是您要找的課程,您也可以百度查找一下: