我写了一条语句如下
select batchno,stored,ordernum, sum(stored) as prostored from process group by batchno,stored,ordernum但我还想进一步操作 把新产生的字段 prostored 的值减去 ordernum的值的结果
小于10的记录挑选出来,怎么做?
select batchno,stored,ordernum, sum(stored) as prostored from process group by batchno,stored,ordernum但我还想进一步操作 把新产生的字段 prostored 的值减去 ordernum的值的结果
小于10的记录挑选出来,怎么做?
having sum(stored) - ordernum < 10
试试
into #temp
from process
group by batchno,stored,ordernumselect * from #temp
where (prostored-ordernum)<10
having sum(stored)-ordernum <10