-
Notifications
You must be signed in to change notification settings - Fork 0
/
test.sql
103 lines (102 loc) · 4.67 KB
/
test.sql
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
select name from stu where id > 95, age=10;
create table stu (id int, age int, name varchar(10));
insert into stu values (1, 10, 'student1' );
insert into stu values (2, 10, 'student2' );
insert into stu values (3, 10, 'student3' );
insert into stu values (4, 10, 'student4' );
insert into stu values (5, 10, 'student5' );
insert into stu values (6, 10, 'student6' );
insert into stu values (7, 10, 'student7' );
insert into stu values (8, 10, 'student8' );
insert into stu values (9, 10, 'student9' );
insert into stu values (10, 10, 'student10' );
insert into stu values (11, 10, 'student11' );
insert into stu values (12, 10, 'student12' );
insert into stu values (13, 10, 'student13' );
insert into stu values (14, 10, 'student14' );
insert into stu values (15, 10, 'student15' );
insert into stu values (16, 10, 'student16' );
insert into stu values (17, 10, 'student17' );
insert into stu values (18, 10, 'student18' );
insert into stu values (19, 10, 'student19' );
insert into stu values (20, 10, 'student20' );
insert into stu values (21, 10, 'student21' );
insert into stu values (22, 10, 'student22' );
insert into stu values (23, 10, 'student23' );
insert into stu values (24, 10, 'student24' );
insert into stu values (25, 10, 'student25' );
insert into stu values (26, 10, 'student26' );
insert into stu values (27, 10, 'student27' );
insert into stu values (28, 10, 'student28' );
insert into stu values (29, 10, 'student29' );
insert into stu values (30, 10, 'student30' );
insert into stu values (31, 10, 'student31' );
insert into stu values (32, 10, 'student32' );
insert into stu values (33, 10, 'student33' );
insert into stu values (34, 10, 'student34' );
insert into stu values (35, 10, 'student35' );
insert into stu values (36, 10, 'student36' );
insert into stu values (37, 10, 'student37' );
insert into stu values (38, 10, 'student38' );
insert into stu values (39, 10, 'student39' );
insert into stu values (40, 10, 'student40' );
insert into stu values (41, 10, 'student41' );
insert into stu values (42, 10, 'student42' );
insert into stu values (43, 10, 'student43' );
insert into stu values (44, 10, 'student44' );
insert into stu values (45, 10, 'student45' );
insert into stu values (46, 10, 'student46' );
insert into stu values (47, 10, 'student47' );
insert into stu values (48, 10, 'student48' );
insert into stu values (49, 10, 'student49' );
insert into stu values (50, 10, 'student50' );
insert into stu values (51, 10, 'student51' );
insert into stu values (52, 10, 'student52' );
insert into stu values (53, 10, 'student53' );
insert into stu values (54, 10, 'student54' );
insert into stu values (55, 10, 'student55' );
insert into stu values (56, 10, 'student56' );
insert into stu values (57, 10, 'student57' );
insert into stu values (58, 10, 'student58' );
insert into stu values (59, 10, 'student59' );
insert into stu values (60, 10, 'student60' );
insert into stu values (61, 10, 'student61' );
insert into stu values (62, 10, 'student62' );
insert into stu values (63, 10, 'student63' );
insert into stu values (64, 10, 'student64' );
insert into stu values (65, 10, 'student65' );
insert into stu values (66, 10, 'student66' );
insert into stu values (67, 10, 'student67' );
insert into stu values (68, 10, 'student68' );
insert into stu values (69, 10, 'student69' );
insert into stu values (70, 10, 'student70' );
insert into stu values (71, 10, 'student71' );
insert into stu values (72, 10, 'student72' );
insert into stu values (73, 10, 'student73' );
insert into stu values (74, 10, 'student74' );
insert into stu values (75, 10, 'student75' );
insert into stu values (76, 10, 'student76' );
insert into stu values (77, 10, 'student77' );
insert into stu values (78, 10, 'student78' );
insert into stu values (79, 10, 'student79' );
insert into stu values (80, 10, 'student80' );
insert into stu values (81, 10, 'student81' );
insert into stu values (82, 10, 'student82' );
insert into stu values (83, 10, 'student83' );
insert into stu values (84, 10, 'student84' );
insert into stu values (85, 10, 'student85' );
insert into stu values (86, 10, 'student86' );
insert into stu values (87, 10, 'student87' );
insert into stu values (88, 10, 'student88' );
insert into stu values (89, 10, 'student89' );
insert into stu values (90, 10, 'student90' );
insert into stu values (91, 10, 'student91' );
insert into stu values (92, 10, 'student92' );
insert into stu values (93, 10, 'student93' );
insert into stu values (94, 10, 'student94' );
insert into stu values (95, 10, 'student95' );
insert into stu values (96, 10, 'student96' );
insert into stu values (97, 10, 'student97' );
insert into stu values (98, 10, 'student98' );
insert into stu values (99, 10, 'student99' );
insert into stu values (100, 10, 'student100' );