Window function POSTGRESQL
YEAR sales 2021 1000 2022 1500 2023 2000 I want show 3rd column min sales with window function. But year=2022. YEAR sales min 2021 1000 1500 2022 1500 1500 2023 2000 1500 I've tried the following query, but it didn't…
Postgresql – Sum a column based on a condition in another column with partitions
I'm trying to sum a column based on a condition in another column with partition by in SQL, but it's not working. So I hope somebody can help me with this. My table is like this: Group_1 Group_2 Date Value…