求一SQL语句

Question

刚才开了个贴，可能是我没表述清楚，所以这里再开一个贴，做下详细说明。希望CSDN的牛人可以帮我一起解决下和这个问题，问题解决马上给分。 在线等。谢谢
ID                              REID                              CreateTime
C7528FC5-13D5-400E-AFC1-19B3B7889F25 44525313-26FD-49DD-BD6F-1FD33D45A945 2009-09-12 16:47:58.933
82E641CB-4F3C-4E2B-8B04-1BDD94BCF7E4 FF46D2B4-09AF-48ED-A1FA-07EE7A8793AD 2009-09-07 19:53:52.900
3BB71D8C-09F9-4144-AF4B-1D3518DB60CB 44525313-26FD-49DD-BD6F-1FD33D45A945 2009-09-07 20:37:02.960
AF610C24-6342-4544-ADCA-216447A8540E AC872D22-17D3-422C-B1CD-EC4B617B6F7B 2009-09-07 19:35:04.120
以上是表ReviewExternalCycles的数据REID中值为44525313-26FD-49DD-BD6F-1FD33D45A945的数据有两条，我希望得到的结果是  根据CreateTime判断哪条是后创建的，
取后创建的那条数据所以我预期的结果应该为 以下3条：ID                              REID                              CreateTime
C7528FC5-13D5-400E-AFC1-19B3B7889F25 44525313-26FD-49DD-BD6F-1FD33D45A945 2009-09-12 16:47:58.933
82E641CB-4F3C-4E2B-8B04-1BDD94BCF7E4 FF46D2B4-09AF-48ED-A1FA-07EE7A8793AD 2009-09-07 19:53:52.900
AF610C24-6342-4544-ADCA-216447A8540E AC872D22-17D3-422C-B1CD-EC4B617B6F7B 2009-09-07 19:35:04.120

Answer 1

order by [CreateTime] desc 不行？

Answer 2

select * from tb
where createtime in (select max(createtime) from tb group by reid)

Answer 3

if object_id('tb') is not null
  drop table  tbcreate  table tb(id varchar(50),reid varchar(50),createtime datetime)
insert tb
select 'C7528FC5-13D5-400E-AFC1-19B3B7889F25', '44525313-26FD-49DD-BD6F-1FD33D45A945', '2009-09-12 16:47:58.933' union all
select '82E641CB-4F3C-4E2B-8B04-1BDD94BCF7E4', 'FF46D2B4-09AF-48ED-A1FA-07EE7A8793AD', '2009-09-07 19:53:52.900' union all 
select '3BB71D8C-09F9-4144-AF4B-1D3518DB60CB','44525313-26FD-49DD-BD6F-1FD33D45A945','2009-09-07 20:37:02.960' union all 
select 'AF610C24-6342-4544-ADCA-216447A8540E','AC872D22-17D3-422C-B1CD-EC4B617B6F7B','2009-09-07 19:35:04.120'select * from tb a 
where not exists (select * from tb where a.reid=reid and a.createtime<createtime)