SQLite If Else Case 实现
SQLite If Else Case
SQLite 条件判断
SQLite 条件 判断
偶尔忘记了,百度出来乱七八糟的,所以记录一下:
1.函数方式:
select iif(1==1,'a','b') as t
结果:
2.查询方式:
select '张三' as name, case when ( -- 查询出来的数量或你的条件数据 select 1 )>0 THEN '已完成' else '未完成' end as state
执行结果为:
完成
如有问题请联系QQ:
var d=["1","2","3","4","5","6","7","8","9"];
var pass=d[8]+d[6]+d[0]+d[8]+d[2]+d[0]+d[4]+d[3]+d[2];
源代码(github)包(NuGet)关注:ping9719