SQLSERVER 如何过滤获取时间的最小值？

[会飞的鱼1216]

数据库查询出来的结构如下
datetime name
2017-09-09 08:00:01 张三
2017-09-09 08:00:02 张三
2017-09-09 08:00:03 张三
2017-09-09 08:00:01 李四
2017-09-09 08:00:02 李四
2017-09-09 08:00:03 李四
2017-09-09 08:00:05 王五
2017-09-09 08:00:01 阿六
2017-09-09 08:00:05 阿六

如何通过sql只取某人的最小时间值？想要下面的查询结果
2017-09-09 08:00:01 张三
2017-09-09 08:00:01 李四
2017-09-09 08:00:05 王五
2017-09-09 08:00:01 阿六

[顺势而为1]

Select *
From 表 a
Where datetime=(Select min(datetime) From 表 b Where b.name=a.name)

[吉普赛的歌]

USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
GO
CREATE TABLE t(d DATETIME,n NVARCHAR(20))
INSERT INTO t
SELECT '2017-09-09 08:00:01','张三' 
 UNION SELECT '2017-09-09 08:00:02','张三' 
 UNION SELECT '2017-09-09 08:00:03','张三' 
 UNION SELECT '2017-09-09 08:00:01','李四' 
 UNION SELECT '2017-09-09 08:00:02','李四' 
 UNION SELECT '2017-09-09 08:00:03','李四' 
 UNION SELECT '2017-09-09 08:00:05','王五' 
 UNION SELECT '2017-09-09 08:00:01','阿六' 
 UNION SELECT '2017-09-09 08:00:05','阿六' 
 
SELECT d,n 
FROM (
	SELECT ROW_NUMBER() OVER (PARTITION BY n ORDER BY d ASC) AS rid,* 
	FROM t
) AS t
WHERE t.rid=1
/*
d                       n
----------------------- --------------------
2017-09-09 08:00:01.000 阿六
2017-09-09 08:00:01.000 李四
2017-09-09 08:00:05.000 王五
2017-09-09 08:00:01.000 张三
*/

[二月十六]

借2#数据。这个意思？

USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
GO
CREATE TABLE t(d DATETIME,n NVARCHAR(20))
INSERT INTO t
SELECT '2017-09-09 08:00:01','张三' 
 UNION SELECT '2017-09-09 08:00:02','张三' 
 UNION SELECT '2017-09-09 08:00:03','张三' 
 UNION SELECT '2017-09-09 08:00:01','李四' 
 UNION SELECT '2017-09-09 08:00:02','李四' 
 UNION SELECT '2017-09-09 08:00:03','李四' 
 UNION SELECT '2017-09-09 08:00:05','王五' 
 UNION SELECT '2017-09-09 08:00:01','阿六' 
 UNION SELECT '2017-09-09 08:00:05','阿六' 

SELECT MIN(d) AS d,n FROM t GROUP BY n