ZRiQ0Npp

1DROP TABLE IF EXISTS t;
2CREATE TABLE t
3(
4    id    int unsigned not null,
5    value int unsigned null
6);
7INSERT INTO t
8values (1, null);
9
10CREATE OR REPLACE VIEW v
11as
12select 1               as id,
13       ifnull(null, 999) as value
14from t
15;
16
17select *,
18       MIN(t.value) over (PARTITION BY t.id) as min_t,
19       MIN(v.value) over (PARTITION BY t.id) as min_v
20from t
21         left join v
22                   on t.id > v.id
23;