sql code

Õâsql Óï¾äдµÄÕæµÄºÜ²»´í! 
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([col1] bigint,[col2] varchar(6),[col3] varchar(6))
insert [tb]
select 130126200201000275,'ÍõÎÄϼ','½ù´¨´¨' union all
select 130126200201000275,'ÍõÎÄϼ','½ù澤' union all
select 130126200201000275,'ÍõÎÄϼ','aaaa' union all
select 130126200201000276,'ÖÜ書¶ð','³Ì˼³¬' union all
select 130126200201000276,'ÖÜ書¶ð','³Ìٮٮ' union all
select 130126200201000277,'風¾Õ','³ÌÇàÇà' union all
select 130126200201000277,'風¾Õ','³Ì¶þС' union all
select 130126200201000278,'張Ó¢ÌÒ','³Ì´ó慶' union all
select 130126200201000278,'張Ó¢ÌÒ','³ÌС»¨'
--------------¿ªÊ¼²éѯ--------------------------
select * from tb 
select col2,col3 from
(
select col1,col2,col3 from [tb] t
where not exists(select * from tb where col1=t.col1 and col2=t.col2 and col3>t.col3)
union all
select col1,'',col3 from [tb] t
where exists(select 1 from tb where col1=t.col1 and col2=t.col2 and col3>t.col3)
)T
order by col1,col3 desc