SQLÓï¾äµÄÎÊÌâ

SELECT * from (SELECT ROW_NUMBER(order by strId) AS rownum,x.dtTime from TbRecord as x,TbD,TbB,TbType WHERE (x.strId=TbD.strId) and (x.strCode=TbD.strCode) and (TbD.strCode=TbB.strCode) and (NOT EXISTS(SELECT 1 AS Expr1 from TbRecord WHERE (strId = x.strId) AND (strCode = x.strCode) AND (dtTime>x.dtTime)))) AS T

ÒÔÉÏÓï¾äµÄÄ¿µÄÊÇҪȡ³östrCode(´óµÄ±àºÅ),strId£¨Ð¡µÄ±àºÅ£©ÏàͬµÄ¼Ç¼ÖÐʱ¼ä×î´óµÄÒ»Ìõ¼Ç¼£¬Ö»È¡Ò»Ìõ£¬Ö´ÐеÄʱºòÓеļǼ»á³öÏÖÁ½Ìõ£¬
±ÈÈç0001(strCode) 2(strId)µÄ¼Ç¼»áÓÐÁ½Ìõ£¬Çë°ïÎÒ·ÖÎöÏÂÊÇʲôԭÒò£¿

---

¼ÈÈ»ÊÇ05 ¾ÍÓÃ
id=ROW_NUMBER(partition by strCode,strId order by dtTime desc)
È»ºóÈ¡µÈÓÚ1µÄ

---

Çë¸ø³öÊý¾ÝÀ´

---

ÒýÓÃ

Çë¸ø³öÊý¾ÝÀ´

..

---

SQL code:
select * from(
SELECT ROW_NUMBER() over(partition by x.strCode, x.strId order by x.dtTime desc) AS rownum
,x.dtTime from TbRecord as x,TbD,TbB,TbType
WHERE (x.strId=TbD.strId)
and (x.strCode=TbD.strCode)
and (TbD.strCode=TbB.strCode)

where rownum=1

---

SQL code:
select * from(
SELECT ROW_NUMBER() over(partition by x.strCode, x.strId order by x.dtTime desc) AS rownum
,x.dtTime from TbRecord as x,TbD,TbB,TbType
WHERE (x.strId=TbD.strId)
and (x.strCode=TbD.strCode)
and (TbD.st