oceanbase

1
drop table if exists t1;
2
CREATE TABLE t1 (
3
id int,
4
token varchar(100) ,
5
count int ,
6
qty int,
7
phone char(1) ,
8
stamp datetime ,
9
PRIMARY KEY (id)
10
);
11
INSERT INTO t1 VALUES (21,'e45703b64de71482360de8fec94c3ade',3,7800,'n','1999-12-23 17:22:21');
12
INSERT INTO t1 VALUES (22,'e45703b64de71482360de8fec94c3ade',4,5000,'y','1999-12-23 17:22:21');
13
INSERT INTO t1 VALUES (18,'346d1cb63c89285b2351f0ca4de40eda',3,13200,'b','1999-12-23 11:58:04');
14
INSERT INTO t1 VALUES (17,'ca6ddeb689e1b48a04146b1b5b6f936a',4,15000,'b','1999-12-23 11:36:53');
15
INSERT INTO t1 VALUES (16,'ca6ddeb689e1b48a04146b1b5b6f936a',3,13200,'b','1999-12-23 11:36:53');
16
INSERT INTO t1 VALUES (26,'a71250b7ed780f6ef3185bfffe027983',5,1500,'b','1999-12-27 09:44:24');
17
INSERT INTO t1 VALUES (24,'4d75906f3c37ecff478a1eb56637aa09',3,5400,'y','1999-12-23 17:29:12');
18
INSERT INTO t1 VALUES (25,'4d75906f3c37ecff478a1eb56637aa09',4,6500,'y','1999-12-23 17:29:12');
19
INSERT INTO t1 VALUES (27,'a71250b7ed780f6ef3185bfffe027983',3,6200,'b','1999-12-27 09:44:24');
20
INSERT INTO t1 VALUES (28,'a71250b7ed780f6ef3185bfffe027983',3,5400,'y','1999-12-27 09:44:36');
21
INSERT INTO t1 VALUES (29,'a71250b7ed780f6ef3185bfffe027983',4,17700,'b','1999-12-27 09:45:05');
22
select t1000.id from
23
t1 as t1000
24
left join t1 as t2000 on t1000.id=t2000.id
25
left join t1 as t2001 on t2000.id=t2001.id
26
left join t1 as t2002 on t2001.id=t2002.id
27
left join t1 as t2003 on t2002.id=t2003.id
28
left join t1 as t2004 on t2003.id=t2004.id
29
left join t1 as t2005 on t2004.id=t2005.id
30
left join t1 as t2006 on t2005.id=t2006.id
31
left join t1 as t2007 on t2006.id=t2007.id
32
left join t1 as t2008 on t2007.id=t2008.id
33
left join t1 as t2009 on t2008.id=t2009.id
34
left join t1 as t2010 on t2009.id=t2010.id
35
left join t1 as t2011 on t2010.id=t2011.id
36
left join t1 as t2012 on t2011.id=t2012.id
37
left join t1 as t2013 on t2012.id=t2013.id
38
left join t1 as t2014 on t2013.id=t2014.id
39
left join t1 as t2015 on t2014.id=t2015.id
40
left join t1 as t2016 on t2015.id=t2016.id
41
left join t1 as t2017 on t2016.id=t2017.id
42
left join t1 as t2018 on t2017.id=t2018.id
43
left join t1 as t2019 on t2018.id=t2019.id
44
left join t1 as t2020 on t2019.id=t2020.id
45
left join t1 as t2021 on t2020.id=t2021.id
46
left join t1 as t2022 on t2021.id=t2022.id
47
left join t1 as t2023 on t2022.id=t2023.id
48
left join t1 as t2024 on t2023.id=t2024.id
49
left join t1 as t2025 on t2024.id=t2025.id
50
left join t1 as t2026 on t2025.id=t2026.id
51
left join t1 as t2027 on t2026.id=t2027.id
52
left join t1 as t2028 on t2027.id=t2028.id
53
left join t1 as t2029 on t2028.id=t2029.id
54
left join t1 as t2030 on t2029.id=t2030.id
55
left join t1 as t2031 on t2030.id=t2031.id;
56
id
57
16
58
17
59
18
60
21
61
22
62
24
63
25
64
26
65
27
66
28
67
29
68
drop table t1;
69