oracle中case when语法
来源:互联网 发布:ec软件下载2016 编辑:程序博客网 时间:2024/05/18 22:11
Case
When Fd_Business.Amount_Debit > 0 And
Fd_Business.Syscreate_Type <> 5 And
Fd_Business.Fd_Fund_Account_Id In
(Select Fd_Fund_Account_Id
From Fd_Fund_Account Ffa
Where Ffa.Fund_Account_Type = 'C') Then
'现金收款'
When Fd_Business.Amount_Debit > 0 And
Fd_Business.Syscreate_Type <> 5 And
Fd_Business.Fd_Fund_Account_Id In
(Select Fd_Fund_Account_Id
From Fd_Fund_Account Ffa
Where Ffa.Fund_Account_Type = 'B') Then
'银行收款'
When Fd_Business.Amount_Credit > 0 And
Fd_Business.Syscreate_Type <> 5 And
Fd_Business.Syscreate_Type <> 8 and
Fd_Business.Fd_Fund_Account_Id In
(Select Fd_Fund_Account_Id
From Fd_Fund_Account Ffa
Where Ffa.Fund_Account_Type = 'C') Then
'现金付款'
When Fd_Business.Amount_Credit > 0 And
Fd_Business.Syscreate_Type = 8 And
Fd_Business.Fd_Fund_Account_Id In
(Select Fd_Fund_Account_Id
From Fd_Fund_Account Ffa
Where Ffa.Fund_Account_Type = 'C') Then
'现金工资发放'
When fd_Business.Amount_Credit > 0 And
Fd_Business.Syscreate_Type <> 5 And
Fd_Business.Syscreate_Type <> 8 and
Fd_Business.Fd_Fund_Account_Id In
(Select Fd_Fund_Account_Id
From Fd_Fund_Account Ffa
Where Ffa.Fund_Account_Type = 'B') Then
'银行付款'
When fd_Business.Amount_Credit > 0 And
Fd_Business.Syscreate_Type = 8 And
Fd_Business.Fd_Fund_Account_Id In
(Select Fd_Fund_Account_Id
From Fd_Fund_Account Ffa
Where Ffa.Fund_Account_Type = 'B') Then
'银行工资发放'
When Fd_Business.Syscreate_Type = 5 Then
'银行存取款'
Else
'其他'
End Ontheway_Billno,
- oracle中case when语法
- Oracle select case when 语法
- sql 中 case when 语法
- sql 中 case when 语法
- sql 中 case when 语法
- sql 中 case when 语法
- sql 中 case when 语法
- sql 中 case when 语法
- sql 中 case when 语法
- SQL中case when 语法
- sql 中 case when 语法
- Oracle中case when用法
- oracle case when else 语法和用法
- sql 中 case when 超炫语法
- sql 中 case when 语法详解
- case when 语法
- SQL case when语法
- sql语法 case when
- Postgresql 触发器一例
- 区分什么时候调用构造函数,复制构造函数和赋值操作符例子
- 形式化函数(加法)
- JAVA API系列----Hashtable类
- 命令行启动/卸载 Oracle 10 监听和服务
- oracle中case when语法
- 形式化函数(幂次方)
- fork调用,父进程返回子进程的ID,子进程返回0,如果调用失败就返回负数
- 形式化函数(乘法)
- Win32的文件夹遍历方法之递归写法
- QQ空间签到说说表情代码大全
- 形式语义加法
- 研一下第5周3.21-3.27规划
- chrome里面的about Scheme