ÇóÒ»ÌõSQLÓï¾ä¡£

ID  ²Í±ð    ʱ¼ä
1  ÖÐ²Í 2009-10-25
2  ÖÐ²Í 2009-10-26
3  Íí²Í 2009-10-26
4  Ôç²Í 2009-10-27

½á¹û
1  ÖÐ²Í 2009-10-25
3  Íí²Í 2009-10-26
4  Ôç²Í 2009-10-27

ÈÕÆÚÖÐÓÐÖظ´µÄ¡£¡£ÎÒÏëÒ»Ö±µÃµ½×îеġ£¡£°ïæллÁË

---

ËäÈ»¶Ô´ó¼ÒÓÐЩ¼òµ¥¡£µ«ÊÇÓÐûÓо­µäµÄË㷨ѽ¡£
ÕâÖÖÎÊÌâÔÚ±¨±íÖÐ×ÜÊdzöÏÖ¡£¡£

---

UP

---

SQL code:

select * from tb a where not exists(select 1 from tb where a.²Í±ð=²Í±ð and a.ʱ¼ä<ʱ¼ä)

---

SQL code:

--> ²âÊÔÊý¾Ý: @T1
declare @T1 table (ID int,²Í±ð varchar(4),ʱ¼ä datetime)
insert into @T1
select 1,'ÖвÍ','2009-10-25' union all
select 2,'ÖвÍ','2009-10-26' union all
select 3,'Íí²Í','2009-10-26' union all
select 4,'Ôç²Í','2009-10-27'

select * from @t1 a where not exists(select 1 from @t1 where a.²Í±ð=²Í±ð and a.ʱ¼ä> ʱ¼ä)

ID ²Í±ð ʱ¼ä
----------- ---- ------------------------------------------------------
1 ÖÐ²Í 2009-10-25 00:00:00.000
3 Íí²Í 2009-10-26 00:00:00.000
4 Ôç²Í 2009-10-27 00:00:00.000

£¨ËùÓ°ÏìµÄÐÐÊýΪ 3 ÐУ©
3Â¥Óеã´íÎó

---

SQL code
{{-