Do you have much experience with Postgres WINDOW expressions? Yes. SELECT DISTINCT a, first_value(b) OVER (PARTITION BY a ORDER BY x), ...
確定! 回上一頁