不同时间入库的相同药品中，只获取最后一次入库的药品信息的方法

--不同时间入库的相同药品中，只获取最后一次入库的药品信息的方法
select A.* from 
(
 SELECT id, stockid, drugid, drugunit, packsize, stockamount, retailprice, 
       supplyid, drugtype, product, remark, drugspec, sellqty, drugstate, 
       purchaseid, costprice, producedate, creater, creatertiem, purchaseamount, 
       retailamount, drugbatch, purchangeprice, validdate
  FROM dg_stockdetail 
 )A,
 (
select drugid, max(creatertiem) as createtime from dg_stockdetail group by drugid
 )B
 where A.drugid=B.drugid and A.creatertiem = B.createtime 
 order by A.drugid






-- 
--  SELECT id, stockid, drugid, drugunit, packsize, stockamount, retailprice, 
--        supplyid, drugtype, product, remark, drugspec, sellqty, drugstate, 
--        purchaseid, costprice, producedate, creater, creatertiem, purchaseamount, 
--        retailamount, drugbatch, purchangeprice, validdate
--   FROM dg_stockdetail 
--   where creatertiem in(select max(creatertiem) from dg_stockdetail group by drugid) 
-- order by drugid