create table t1 (i int);

insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);

select i, Min(i) OVER (PARTITION BY i) as f from (select * from t1) as tt order by i;

+------+------+

| i    | f    |

+------+------+

|    1 |   10 |

|    2 |   10 |

|    3 |   10 |

|    4 |   10 |

|    5 |   10 |

|    6 |   10 |

|    7 |   10 |

|    8 |   10 |

|    9 |   10 |

|   10 |   10 |

+------+------+

10 rows in set (0.00 sec)

MariaDB [test]> select i, Min(i) OVER (PARTITION BY i) as f from t1 as tt order by i;

+------+------+

| i    | f    |

+------+------+

|    1 |    1 |

|    2 |    2 |

|    3 |    3 |

|    4 |    4 |

|    5 |    5 |

|    6 |    6 |

|    7 |    7 |

|    8 |    8 |

|    9 |    9 |

|   10 |   10 |

+------+------+

10 rows in set (0.01 sec)

postgres=# select i, Min(i) OVER (PARTITION BY i) as f from t1 as tt order by i;

 i  | f  

----+----

  1 |  1

  2 |  2

  3 |  3

  4 |  4

  5 |  5

  6 |  6

  7 |  7

  8 |  8

  9 |  9

 10 | 10

(10 rows)

postgres=# select i, Min(i) OVER (PARTITION BY i) as f from (select * from t1) as tt order by i;

 i  | f  

----+----

  1 |  1

  2 |  2

  3 |  3

  4 |  4

  5 |  5

  6 |  6

  7 |  7

  8 |  8

  9 |  9

 10 | 10

(10 rows)