postgresql - Postgressql - 是否可以区分这两个值是否为真？

Question

我有以下查询，只有当值 id 和类型相同时，我才想通过用户 id 来区分：

SELECT DISTICT ON (us.id) us.id AS id en.type AS type
FROM enrollment AS en
INNER JOIN "user" AS us ON us.id = en.user_id

标签： postgresql