1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
select
'first',
coalesce(first_null, 22),
coalesce(first_num, 33),
coalesce(coalesce(first_null, 122), 42),
coalesce(coalesce(first_num, 133), 43),
coalesce(coalesce(coalesce(first_null, 222), 442), 100500),
coalesce(coalesce(coalesce(first_num, 233), 443), 100501),
'second',
coalesce(second_null, 22),
coalesce(second_num, 33),
coalesce(coalesce(second_null, 122), 42),
coalesce(coalesce(second_num, 133), 43),
coalesce(coalesce(coalesce(second_null, 222), 442), 100500),
coalesce(coalesce(coalesce(second_num, 233), 443), 100501),
'third',
coalesce(third_null, 22),
coalesce(third_num, 33),
coalesce(coalesce(third_null, 122), 42),
coalesce(coalesce(third_num, 133), 43),
coalesce(coalesce(coalesce(third_null, 222), 442), 100500),
coalesce(coalesce(coalesce(third_num, 233), 443), 100501),
'end'
from plato.Input;
|
