17,140
社区成员




CREATE TABLE T128
(
MyDate VARCHAR2(20),
CODE VARCHAR2(20),
MyNumber NUMBER
);
INSERT INTO T128 VALUES('19870401', 'TWEN', 58992);
INSERT INTO T128 VALUES('19870402', 'TWEN', 34700);
INSERT INTO T128 VALUES('19870403', 'TWEN', 171123);
INSERT INTO T128 VALUES('19870404', 'TWEN', 205239);
INSERT INTO T128 VALUES('19870405', 'TWEN', 73000);
INSERT INTO T128 VALUES('19870406', 'TWEN', 92216);
INSERT INTO T128 VALUES('19870407', 'TWEN', 60700);
INSERT INTO T128 VALUES('19860324', 'XYZ', 27306);
INSERT INTO T128 VALUES('19860325', 'XYZ', 33600);
INSERT INTO T128 VALUES('19860326', 'XYZ', 12607);
INSERT INTO T128 VALUES('19860327', 'XYZ', 63013);
INSERT INTO T128 VALUES('19860328', 'XYZ', 42674);
INSERT INTO T128 VALUES('19860329', 'XYZ', 139275);
INSERT INTO T128 VALUES('19860330', 'XYZ', 46708);
INSERT INTO T128 VALUES('19860331', 'XYZ', 18170);
INSERT INTO T128 VALUES('19870401', 'XYZ', 18170);
INSERT INTO T128 VALUES('19870402', 'XYZ', 18170);
INSERT INTO T128 VALUES('19870403', 'XYZ', 10535);
INSERT INTO T128 VALUES('19870404', 'XYZ', 10535);
INSERT INTO T128 VALUES('19870405', 'XYZ', 212410);
INSERT INTO T128 VALUES('19870406', 'XYZ', 51900);
INSERT INTO T128 VALUES('19870407', 'XYZ', 13020);