å å辨ä¸åºåªä¸ªæ¯ååï¼é¾æ¥å°±ä¸å äºã建ç«è¡¨ç»æå¦ä¸ï¼CREATE table [dbo].[tmp_Trans](
ID int identity,
PO_NO varchar(20) null,
PO_Itemno varchar(20) null,
Qty numeric(18,6) null,
Trans_Date datetime null,
Doc_no varchar(20) null
)è¦æ±åç¸åPO_NOæTrans_Dateååºæåºçå两æ¡è®°å½ã1.Whereåå¥åµå¥SELECTçæ¹å¼ãå¨åµå¥çSELECTè¯å¥ä¸å¯ä»¥ä¸ä¸»è¡¨çå段ç¸å
³èï¼è¾¾å°åç±»çç®çãè¿ç§æ¹å¼åæä¸ç§åæ³ï¼1ï¼å¦æ表ä¸æ主é®ï¼å¯ä»¥ç¨INçæ¹å¼ãSELECT * FROM tmp_Trans t
WHERE ID IN(
SELECT TOP 2 ID
FROM tmp_Trans
WHERE PO_NO=t.PO_NO
ORDER BY Trans_Date DESC
) 2ï¼å¦æ没æ主é®ï¼å¯ä»¥ç¨å¤æå¨æ¬æ¡è®°å½åæå¤å°æ¡è®°å½çæ¹å¼ãä½ä½¿ç¨è¿ç§æ¹å¼æ¶å¦æéå°Trans_Dateç¸åçæ
åµä¼ä¸åãå¦å½åå¨Trans_Dateæ大çè®°å½æä¸æ¡æ¶ï¼è¿ä¸æ¡è®°å½é½ä¼æ¥åºæ¥ãSELECT *
FROM tmp_Trans tWHERE (SELECT COUNT(*)
FROM tmp_Trans
WHERE PO_NO=t.PO_NO AND Trans_Date>T.Trans_Date
)
温馨提示:内容为网友见解,仅供参考