Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 16.0 (Debian 16.0-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

SELECT 1

CREATE TABLE mytable ( 
YEAR INT ,
sales INT );

INSERT INTO  mytable  VALUES
('2021','1000'),
('2022','1500'),
('2023','2000');

CREATE TABLE

INSERT 0 3

select *,min(sales) over (partiton by year=2022) from mytable;

ERROR:  syntax error at or near "by"
LINE 1: select *,min(sales) over (partiton by year=2022) from mytabl...
                                           ^

select 
  *,
  min(sales) over (partition by year=2022)
from mytable
order by year;

year
sales
min

2021
1000
1000

2022
1500
1500

2023
2000
1000

SELECT 3