DB2查询药房中的重复批次的药品

admin

---查询药房中的重复批次的药


SELECT *FROM YW_YF_YPKC WHERE YYBM='001' AND YPBM IN(SELECT YPBM FROM YW_YF_YPKC WHERE YYBM='001' GROUP BY YFBM,YPBM,PC HAVING COUNT(*)>1) ORDER BY YPBM;