blob: b506121c94f88c34f82a725c432cab65f42229fd (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
select key from
(
select key, subkey from
(
select 1 as key, "foo" as subkey
union all
select 2 as key, "bar" as subkey
union all
select 3 as key, 123 as subkey
)
)
order by key;
select key from
(
select * from
(
select 4 as key, "baz" as subkey
union all
select 5 as key, "goo" as subkey
union all
select 6 as key, 456 as subkey
)
)
order by key;
|