sql - 在 ms 访问中按随机列分组

Question

我在 MS ACCESS SQL 中需要这样的东西

SELECT 
    ID, 
    col1, 
    col2, 
    random(col3) 
FROM 
    table
GROUP BY
    ID, 
    col1, 
    col2

笔记：

我想删除选择 col3 随机值的重复项。

输入：

+----+------+------+------+
| Id | col1 | col2 | col3 |
+----+------+------+------+
| 1  | A    | B    | 7    |
+----+------+------+------+
| 1  | A    | B    | 10   |
+----+------+------+------+

结果：

+----+------+------+------+
| Id | col1 | col2 | col3 |
+----+------+------+------+
| 1  | A    | B    | 7    |
+----+------+------+------+

请求：

+----+------+------+------+
| Id | col1 | col2 | col3 |
+----+------+------+------+
| 1  | A    | B    | 10   |
+----+------+------+------+

标签： sqlms-access