--mysql
--result=‘yes‘ 没问题；result=‘no‘ 有问题
select companyid,companyname,departmentid,warehouseid,skuid,startinventory,ininventory_hj,outinventory_hj,endinventory,createdate,result from (
select companyid,companyname,departmentid,warehouseid,skuid,a.startinventory,ininventory_hj,outinventory_hj,endinventory,a.createdate,a.rownum,
case when (b.createdate=DATE_add(a.createdate,INTERVAL 1 DAY) && a.endinventory=b.startinventory) || (b.createdate is null && b.rownum is null) then ‘yes‘ else ‘no‘ end result
from (
select companyid,companyname,departmentid,warehouseid,skuid,startinventory,ininventory_hj,outinventory_hj,endinventory
,createdate,@rownum:=@rownum+1 as rownum
from table,(select @rownum:=0) t
order by createdate) a
left join
原文：http://www.cnblogs.com/eboss/p/4897652.html