postgres how to select distinct rows lag lead code example
Example: postgres count distinct
SELECT
COUNT(DISTINCT column)
FROM
table_name
WHERE
condition;
SELECT
COUNT(DISTINCT column)
FROM
table_name
WHERE
condition;