sql 求指定时间段的最大值
·
做个备案
select max(if(ldate>'2012-09-31',ii,0)) as 'minii'
from log_inventory where pa='P/A' and pn='000001' and ldate between '2012-01-01' and '2012-12-31';更多推荐
做个备案
select max(if(ldate>'2012-09-31',ii,0)) as 'minii'
from log_inventory where pa='P/A' and pn='000001' and ldate between '2012-01-01' and '2012-12-31';更多推荐
所有评论(0)