笑傲Java面试：面霸修炼手册

V: ititit111222333

select id,
       sku_code,
       sku_name,
       sku_specs,
       upc,
       warehouse_id,
       cargo_space_id,
       batch_no,
       production_date,
       shelf_life,
       shelf_life_unit,
       expired_date,
       IFNULL((quantity), 0)           as ,
       IFNULL((preempted_quantity), 0) as ,
       IFNULL((available_quantity), 0) as ,
       quantity,
       preempted_quantity,
       available_quantity,
       create_by,
       create_time,
       update_by,
       update_time,
       remove_flag
from st_inventory as where .remove_flag = 0