--基础数据
DROP TABLE "ZYH_TEST";
CREATE TABLE "ZYH_TEST" (
"ID" NUMBER(19) NOT NULL ,
"NAME" VARCHAR2(255 BYTE) ,
"CREATETIME" DATE ,
"SCORE" NUMBER ,
"CLASSID" VARCHAR2(255 BYTE)
)
INSERT INTO "ZYH_TEST" VALUES ('1', 'allen', TO_DATE('2019-01-14 17:41:09', 'SYYYY-MM-DD HH24:MI:SS'), '98.5', '1');
INSERT INTO "ZYH_TEST" VALUES ('2', 'lee', TO_DATE('2019-01-14 17:41:37', 'SYYYY-MM-DD HH24:MI:SS'), '88.5', '1');
INSERT INTO "ZYH_TEST" VALUES ('3', 'me'<
OVER(PARTITION BY)高级查询
最新推荐文章于 2024-04-15 16:46:25 发布