| create table src_null_n1 (a int, b string); |
| insert into src_null_n1 values (1, 'A'); |
| insert into src_null_n1 values (null, null); |
| insert into src_null_n1 values (3, null); |
| insert into src_null_n1 values (2, null); |
| insert into src_null_n1 values (2, 'A'); |
| insert into src_null_n1 values (2, 'B'); |
| |
| SELECT x.* FROM src_null_n1 x ORDER BY a asc; |
| |
| SELECT x.* FROM src_null_n1 x ORDER BY a desc; |
| |
| SELECT x.* FROM src_null_n1 x ORDER BY b asc, a asc nulls last; |
| |
| SELECT x.* FROM src_null_n1 x ORDER BY b desc, a asc; |
| |
| SELECT x.* FROM src_null_n1 x ORDER BY a asc nulls first; |
| |
| SELECT x.* FROM src_null_n1 x ORDER BY a desc nulls first; |
| |
| SELECT x.* FROM src_null_n1 x ORDER BY b asc nulls last, a; |
| |
| SELECT x.* FROM src_null_n1 x ORDER BY b desc nulls last, a; |
| |
| SELECT x.* FROM src_null_n1 x ORDER BY a asc nulls last, b desc; |
| |
| SELECT x.* FROM src_null_n1 x ORDER BY b desc nulls last, a desc nulls last; |
| |
| SELECT x.* FROM src_null_n1 x ORDER BY b asc nulls first, a asc nulls last; |