ÔÚÏßµÈ,ÇóÒ»ÌõSQLÓï¾ä

Óбí,±íÖÐ×ֶΠID Time

IDΪ±êʶÁР Time Ϊʱ¼ä

±íÖÐÊý¾ÝÈçÏÂ
ID  Time
1  2009-11-09 09:07:50.923
2  2009-11-09 09:19:49.687
2  2009-11-09 09:41:42.047

ÎÒÏ£ÍûµÃµ½µÄ½á¹ûÊÇ Ã¿¸öIDÒ»ÌõÊý¾Ý Èç¹ûIDÖظ´ Ôòȡʱ¼ä¿¿Ç°µÄ

ÀýÈçÉϱí ÎÒÏ£ÍûµÃµ½µÄ½á¹ûÈçÏÂ:
1  2009-11-09 09:07:50.923
2  2009-11-09 09:19:49.687


ÔÚÏßµÈ~£¡

---

SQL code:
select * from TB T where not exists(select 1 from TB where t.ID=ID and t.Time>Time)

---

SQL code:
select id ,time from ±í a where not exists (select 1 from ±í id=a.id and time<a.time)

---

SQL code:
select * from tb t where time=(select max(time) from tb where id=t.id)

---

SQL code:
select * from tb t where time=(select min(time) from tb where id=t.id)

---

SQL code:
[Quote=ÒýÓà 5 Â¥ fredrickhu µÄ