oceanbase

1
drop table if exists t1;
2
create table t1(c1 int primary key, c2 int);
3
insert into t1 values(7,3),(8,3),(1,1),(2,0),(3,1),(4,0),(5,2),(6,2);
4
select c1 as a1,c2 as a2 from t1 group by a2 order by a1;
5
a1	a2
6
1	1
7
2	0
8
5	2
9
7	3
10
select c1 as a1,c2 as a2 from t1 group by a1 order by a2;
11
a1	a2
12
2	0
13
4	0
14
1	1
15
3	1
16
5	2
17
6	2
18
7	3
19
8	3
20
select c1 as a1,c2 as a2 from t1 group by a2 order by a2;
21
a1	a2
22
2	0
23
1	1
24
5	2
25
7	3
26
select c1 as a1,c2 as a2 from t1 group by a1 order by a1;
27
a1	a2
28
1	1
29
2	0
30
3	1
31
4	0
32
5	2
33
6	2
34
7	3
35
8	3
36
select c1 as a1,c2 as a2 from t1 order by a2;
37
a1	a2
38
2	0
39
4	0
40
1	1
41
3	1
42
5	2
43
6	2
44
7	3
45
8	3
46
select c1 as a1,c2 as a2 from t1 order by a1;
47
a1	a2
48
1	1
49
2	0
50
3	1
51
4	0
52
5	2
53
6	2
54
7	3
55
8	3
56
select c1 as a1,c2 as a2 from t1 group by a2 having a2>0 order by a1;
57
a1	a2
58
1	1
59
5	2
60
7	3
61
select c1 as a1,c2 as a2 from t1 group by a2 having a2>0 order by a2;
62
a1	a2
63
1	1
64
5	2
65
7	3
66
select c1 as a1,c2 as a2 from t1 group by a2 having a1>0 order by a1;
67
a1	a2
68
1	1
69
2	0
70
5	2
71
7	3
72
select c1 as a1,c2 as a2 from t1 group by a2 having a1>0 order by a2;
73
a1	a2
74
2	0
75
1	1
76
5	2
77
7	3
78
select c1+c2 as total from t1 order by total;
79
total
80
2
81
2
82
4
83
4
84
7
85
8
86
10
87
11
88
select c1, c1+c2 as total from t1 group by total order by c1;
89
c1	total
90
1	2
91
3	4
92
5	7
93
6	8
94
7	10
95
8	11
96
select c1, c1+c2 as total from t1 group by total having c1>2 order by c1 desc;
97
c1	total
98
8	11
99
7	10
100
6	8
101
5	7
102
4	4
103
select c1 as a1, c2 as a2 from t1 where c1>1;
104
a1	a2
105
2	0
106
3	1
107
4	0
108
5	2
109
6	2
110
7	3
111
8	3
112
select c1 as a1, c2 as a2 from t1 where c2>1;
113
a1	a2
114
5	2
115
6	2
116
7	3
117
8	3
118
select c1,c1+c2 as a1 from t1 where c1+c2>2;
119
c1	a1
120
3	4
121
4	4
122
5	7
123
6	8
124
7	10
125
8	11
126