----------------------------
-- Author  :fredrickhu(小F，向高手学习)
-- Date    :2012-07-17 15:04:59
-- Version:
--      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (Intel X86) 
--    Apr 22 2011 11:57:00 
--    Copyright (c) Microsoft Corporation
--    Enterprise Edition on Windows NT 6.1 <X64> (Build 7600: ) (WOW64)
--
----------------------------
--> 测试数据：[table]
if object_id('[table]') is not null drop table [table]
go 
create table [table]([ID] int,[title] varchar(6),[cont1] int,[cont2] int,[addtime] datetime)
insert [table]
select 1,'nihao',2,3,'2011-7-27' union all
select 2,'nihao2',4,5,'2011-7-28' union all
select 3,'nihao',6,7,'2011-7-29' union all
select 4,'nihao3',8,9,'2011-7-20' union all
select 5,'nihao',10,11,'2011-7-21' union all
select 6,'nihao2',12,13,'2011-7-22'
--------------开始查询--------------------------
select
  *,(select count(1) from [table] where title=t.title) 
from
  [table] t
where
  not exists(select 1 from [table] where title=t.title and addtime>t.addtime)
----------------结果----------------------------
/* ID          title  cont1       cont2       addtime                 
----------- ------ ----------- ----------- ----------------------- -----------
2           nihao2 4           5           2011-07-28 00:00:00.000 2
3           nihao  6           7           2011-07-29 00:00:00.000 3
4           nihao3 8           9           2011-07-20 00:00:00.000 1

(3 行受影响)
*/