select * from h_v_Sc_MouldProdInHouseBillList where 库存组织='手机事业部' and CONVERT(varchar(100),日期, 23) >= '2021-10-01' and CONVERT(varchar(100),日期, 23) <= '2022-03-25' and 部门名称 like '%1%' and CONVERT(varchar(100),日期, 23) >= '2021-10-01' and CONVERT(varchar(100),日期, 23) <= '2022-03-25'order by hmainid desc
|
