MS-Access选择非唯一ID的第一行

Question

如何在MS-Access中选择具有相同非唯一ID的两个多行的第一个数据集？

我没有用非唯一ID来设计这个混乱，并且除ID以外的其他字段都是随机字符串值，因此可能是唯一的或重复的。

说我有输入表

Tab_INPUT 
-------------------------- 
| ID | VAL1 | VAL2 | ... | 
- - - - - - - - - - - - - 
| 1 | "A" | "1a" | ... | 
| 2 | "B" | "2b" | ... | 
| 2 | "C" | "2a" | ... | 
| 3 | "D" | "3c" | ... | 
| 3 | "E" | "3b" | ... | 
| 3 | "F" | "3a" | ... | 
| 4 | "G" | "4a" | ... | 
-------------------------- 

我现在要选择为每个不同的ID的第一行，这样即

Tab_OUTPUT (DESIRED) 
-------------------------- 
| ID | VAL1 | VAL2 | ... | 
- - - - - - - - - - - - - 
| 1 | "A" | "1a" | ... | 
| 2 | "B" | "2b" | ... | 
| 3 | "D" | "3c" | ... | 
| 4 | "G" | "4a" | ... | 
-------------------------- 

我不能使用类似

SELECT ID, Min(VAL1), Min(Val2) FROM Tab_INPUT GROUP BY ID 

因为这会弄乱行本身

Tab_OUTPUT (WRONG) 
-------------------------- 
| ID | VAL1 | VAL2 | ... | 
- - - - - - - - - - - - - 
| 1 | "A" | "1a" | ... | 
| 2 | "B" | "2a" | ... | 
| 3 | "D" | "3a" | ... | 
| 4 | "G" | "4a" | ... | 
-------------------------- 

我需要的行itsself保持完好，只是选择先用一个唯一的ID

Answer 1

尝试使用First代替Min：

SELECT ID, First(VAL1) AS Val1, First(Val2) AS Val2 
FROM Tab_INPUT 
GROUP BY ID