一个SQL查询

2005-10-18---f
2006-10-18---a
2007-10-18---c
2008-10-18---a
2009-10-18---b
2010-10-18---b
2011-10-18---a
2012-10-18---a
我要排序成
2005-10-18---f
2006-10-18---a
2008-10-18---a
2011-10-18---a
2012-10-18---a
2007-10-18---c
2009-10-18---b
2010-10-18---b
前面的2010-10-18是时间,还有一个是NAME字段
首先第1是要按时间排序,然后相同的name要排在一起..搞了好久了..整不出来..求高手帮忙啊

---

SQL code:
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([dt] datetime,[name] varchar(1))
insert [tb]
select '2005-10-18','f' union all
select '2006-10-18','a' union all
select '2007-10-18','c' union all
select '2008-10-18','a' union all
select '2009-10-18','b' union all
select '2010-10-18','b' union all
select '2011-10-18','a' union all
select '2012-10-18','a'

---查询
select a.*
from tb a,
(select name,min(dt) as px from tb group by name) b
where a.name=b.name
order by b.px,a.name,a.dt
/**
dt name
----------------------- ----
2005-10-18 00:00:00.000 f
2006-10-18 00:00:00.000 a
2008-10-18 00:00:00.000 a
2011-10-18 00:00:00.000 a
2012-10-18 00:00:00.000 a
2007-10-18 00:00:00.000 c
2009-10-18 00:00:00.000 b
2010-10-18 00:00:00.000 b

(8 行受影响)
**/

---

SQL code

---

Code highlighting produced by Actip