distinct 与order by 联用引发的问题

[shiosank]

PersID time
1 05:00
1 06:00
1 08:00
2 09:00
2 10:00
3 07:00

按照time为顺序，显示distinct PersID
期望显示
1
3
2
select distinct PersID
from tablename
order by time

报错：如果指定了 SELECT DISTINCT，那么 ORDER BY 子句中的项就必须出现在选择列表中。
求解

[feixianxxx]

-- =========================================
-- -----------t_mac 小编-------------
   ---希望有天成为大虾---- 
-- =========================================

IF OBJECT_ID('tb') IS NOT NULL
  DROP TABLE tb
GO
CREATE TABLE tb(persID int ,[time] varchar(10))
go
insert into tb
select  
1   ,             '05:00' union all select 
1   ,             '06:00' union all select 
1   ,             '08:00' union all select 
2   ,             '09:00' union all select 
2    ,            '10:00' union all select 
3    ,            '07:00' 

go
select persid,min(time)as time 
from tb
group by persid
order by time
/*------------
persID      time
----------- ----------
persid      time
----------- ----------
1           05:00
3           07:00
2           09:00
-------*/

[shiosank]

3Q,问题解决！！！！！

[jack_ailly]

group by persid

[SQL77]

SELECT * FROM TB T WHERE NOT EXISTS(SELECT 1 FROM TB WHERE PersID=T.PersID  AND TIME<T.TIME) ORDER BY TIME

[devilidea]

select persID,min([time])as time
from tb 
group by persID order by time asc