第一个case when,ifnull

CREATE VIEW viewRece AS SELECT id,number,SUM(qty) AS qtyRece FROM receving GROUP BY numberCREATE VIEW viewShip AS SELECT id,number,SUM(qty) AS qtyShip FROM ship GROUP BY number;CREATE VIEW viewInv AS SELECT R.number,qtyRece-qtyShip FROM viewRece R LEFT JOIN viewShip S ON R.number=S.numberCREATE VIEW view_Inv3 AS SELECT R.number,(R.qtyRece-(CASE WHEN qtyShip>0 THEN qtyShip ELSE 0 END)) AS qtyInv FROM viewRece R LEFT JOIN viewShip S ON R.number=S.numberCREATE VIEW view_Inv2 AS SELECT R.number,R.qtyRece-ISNULL(S.qtyShip,0) AS qtyInv FROM viewRece R LEFT JOIN viewShip S ON R.number=S.number

CREATE VIEW viewRece AS SELECT id,number,SUM(qty) AS qtyRece FROM receving GROUP BY numberCREATE VIEW viewShip AS SELECT id,number,SUM(qty) AS qtyShip FROM ship GROUP BY number;CREATE VIEW viewInv AS SELECT R.number,qtyRece-qtyShip FROM viewRece R LEFT JOIN viewShip S ON R.number=S.numberCREATE VIEW view_Inv AS SELECT R.number,(CASE WHEN qtyShip>0 THEN qtyShip ELSE 0 END) AS qtyInv FROM viewRece R LEFT JOIN viewShip S ON R.number=S.number

	
				
	
					   
第一个case when,ifnull
	  	   
mysql 中的case when 和ifnull判断
	  	   
MYSQL ifnull 函数 、if判断 、case when、 locate函数
	  	   
sql控制流程语句case when/if/ifnull/null if
	  	   
mysql的IF()、IFNULL()、WHEN CASE的用法
	  	   
MYSQL函数ISNULL、IFNULL、NULLIF、IF、CASE WHEN
	  	   
oracle case when，如果有多个，如果一条记录满足第一个case when就不会再去执行后面的case when
	  	   
sum(CASE IFNULL(status,0) WHEN 'no' THEN 1 ELSE 0 END)
	  	   
mysql的IFNULL、IF、CASE...WHEN...THEN...函数的使用讲解
	  	   
第一个Ansible测试case
	  	   
Mysql中ifNull()/if()/case when用法和Oracle中nvl()/nvl2()/decode()的用法及其比较
	  	   
CASE WHEN
	  	   
Case when
	  	   
CASE WHEN
	  	   
CASE WHEN
	  	   
case when
	  	   
case when
	  	   
CASE WHEN
	     		  
	  	   
Rcp应用在启动时出现找不到org.eclipse.equinox.launcher.Main类错误
	  	   
不安装oracle、3分钟直接用pl/sql连接oracle server
	  	   
vlc源代码分析详解
	  	   
如何用matlab启动.exe文件?
	  	   
php定时计划任务实现方法
	  	   
第一个case when,ifnull
	  	   
CCS5.2 链接器选项之 --stack_size --heap_size
	  	   
【ARM嵌入式Linux系统开发详解 弓雷】【第20章 Linux内核移植】20.1 Linux内核移植要点
	  	   
android 9.png 图片制作
	  	   
转载——电信专业硕士求职路（自信并自强）
	  	   
网络资源下载
	  	   
sgu 137 Funny Strings
	  	   
cglib 介绍 原理 及 使用
	  	   
五种方法查看Ubuntu/Redhat等Linux系统版本号等系统信息