不同时间入库的相同药品中,只获取最后一次入库的药品信息的方法
来源:互联网 发布:淘宝店卖话费充值 编辑:程序博客网 时间:2024/04/28 17:43
--不同时间入库的相同药品中,只获取最后一次入库的药品信息的方法
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
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
0 0
- 不同时间入库的相同药品中,只获取最后一次入库的药品信息的方法
- sqlserver入库时库表的时间插入
- 关于Mysql入库时间的问题
- 获取过去几天的入库单
- 市区对应的编码获取入库过程
- DWG数据的入库
- oracle入库的datetime
- mongodb的简易入库
- rsyslog的入库
- Session入库的作用
- session的信息入库
- 简单的session入库
- session 的入库
- Qgis 数据的入库
- SESSION入库的实现
- SESSION入库的实现
- 预处理入库的方式
- 采购入库单的问题。
- request和response的中文乱码问题
- mysql 乱码
- u-boot源码分析 --- 启动第二阶段003
- Win7安装好后,IIS不能用,报"HTTP 错误 404.3 – Not Found"错误,"HTTP 错误 500.21"
- Android Studio更新后 Eclipse项目导入问题
- 不同时间入库的相同药品中,只获取最后一次入库的药品信息的方法
- 通过注册表屏蔽WIN+L、注销、切换用户等
- SyncTools--->备份数据工具类
- 比较两数大小(指针)
- u-boot源码分析 --- 启动第二阶段004
- 打造属于自己的前端开发神器 -- 给Sublime Text加上Eclipse的光环
- Java回顾之网络通信
- 用于开发移动应用的英特尔® HTML5 工具
- 程序猿也爱学英语(上),有图有真相