728x90
FLAG1
-
SQLD 자격검증실전문제 118번 문제<자격증>/[SQLD] 2023. 3. 19. 14:36
LAG, LEAD 문제 문제. 문제. CREATE TABLE TBL (ID VARCHAR2(10), START_VAL NUMBER, END_VAL NUMBER); INSERT INTO TBL VALUES ('A', 10, 14); INSERT INTO TBL VALUES ('A', 14, 15); INSERT INTO TBL VALUES ('A', 15, 18); INSERT INTO TBL VALUES ('A', 18, 20); INSERT INTO TBL VALUES ('A', 20, 25); INSERT INTO TBL VALUES ('A', 25, NULL); COMMIT; SELECT ID, START_VAL, END_VAL FROM ( SELECT ID, START_VAL, NVL(END_VA..