Õâ¸ö±íµÄSQLÓï¾ä

±íÄÚÈÝ £º
ÕÅÈý 2009-2-11 1000.0000
ÀîËÄ 2009-3-11 1000.0000
ÍõÎå 2009-2-10 200.0000
ÀîËÄ 2009-3-20 2000.0000
ÕÅÈý 2009-3-11 200.0000
ÍõÎå 2009-3-10 200.0000
ͨ¹ýʹÓÃSQLÓï¾ä£¬²é´¦Ã¿¸öÈË×îºóµÄÒ»Ìõ¼Ç¼£¨ÈÕÆÚ×îÍíµÄÒ»Ìì¼Ç¼£©¡£
·µ»ØÈçϽá¹û£º
ÀîËÄ 2009-3-20 2000.0000
ÕÅÈý 2009-3-11 200.0000
ÍõÎå 2009-3-10 200.0000
SQLÓï¾äÔõôд
Çó½â~лл
ÈÕÆÚÊÇDatatime
Çë²âÊÔºó»Ø´ð£¡£¡£¡
Êý¾Ý¿âSQL2000»òÕß2005
¾ÍÒ»¸ö±í ûÓÐIDÁÐ

---

select a.* from TB a
where a.DateTime=(Select Max(b.DateTime) from TB b where a.Name=b.Name)

---

ÒýÓÃ

select a.* from TB a
where a.DateTime=(Select Max(b.DateTime) from TB b where a.Name=b.Name)

Ó¦¸Ã¿ÉÒÔ ¶¥Ò»ÏÂ

---

SQL code:


if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([name] varchar(20),[time] datetime,[money] float)
insert [tb]
select 'ÕÅÈý', '2009-2-11', 1000.0000 union all
select 'ÀîËÄ', '2009-3-11', 3000.0000 union all
select 'ÍõÎå', '2009-2-10', 200.0000 union all
select 'ÀîËÄ', '2009-3-20', 2000.0000 union all
select 'ÕÅÈý', '2009-3-11', 200.0000 union all
select 'ÍõÎå', '2009-3-10', 200.0000
go

select a.* from tb a
where a.time=(Select Max(b.time) from tb b where a.Name=b.Name)

----------------