postgreSQL -选择单次出现

Question

我有以下表格

如果我理解正确，您希望为每个v2组选择id1的不同计数:

SELECT v2, COUNT(DISTINCT id1) AS count_v2
FROM table_A
GROUP BY v2;