SELECT SUM(stock_quantity) AS stock_quantity FROM tbl_goods_stock_v2 WHERE goods_sku=111 AND cus_id=0
SELECT SUM(stock_quantity) AS stock_quantity FROM tbl_goods_stock_v2 WHERE goods_sku=111 AND cus_id!=1
上述两条SQL语句。我想第一条查出的数据减除第二条查出的数据 现在想使用一条语句查出来。该如何改。求解
解决方案 »
- java 向mysql插入中文
- mysql中的substring_index()函数如何用空格做为间隔符啊??
- 多表连接这个表该如何优化
- 二进制日志文件问题
- mysql存储过程 出错。。
- redmine安装遇到问题
- 好消息,MySQL 4.1 正式发布!!!
- 我的系统用的linux+postgresql,现在速度很慢,400分求救!!!
- sos! 请问哪位知道在windows下c++怎样和mysql连接,在下感激不尽
- 各位高手:linux下1、如何配置tomcat的web.xml2、用jdbc连接MySQL的一个问题
- mysql 中文 不同的中文问题
- 为什么执行create table t1 like t2执行了55秒钟?求思路,求想法
SELECT SUM(stock_quantity) AS stock_quantity FROM tbl_goods_stock_v2 WHERE goods_sku=111 AND cus_id=0 ) a,(
SELECT SUM(stock_quantity) AS stock_quantity FROM tbl_goods_stock_v2 WHERE goods_sku=111 AND cus_id!=1 ) b;
SELECT SUM(stock_quantity) AS stock_quantity FROM tbl_goods_stock_v2 WHERE goods_sku=111 AND cus_id=0
union all
SELECT -SUM(stock_quantity) AS stock_quantity FROM tbl_goods_stock_v2 WHERE goods_sku=111 AND cus_id!=1 ) a;
SELECT SUM(stock_quantity) AS stock_quantity into @A FROM tbl_goods_stock_v2 WHERE goods_sku=111 AND cus_id=0;
SELECT SUM(stock_quantity) AS stock_quantity into @B FROM tbl_goods_stock_v2 WHERE goods_sku=111 AND cus_id!=1;
select @A-@B;
还有个小问题 AND cus_id!=1 我想加上不等于0 但不能AND cus_id!=1,0这样写 只能AND cus_id!=1 AND cus_id!=0 请问有简写的方法吗?
谢谢!