RDBMS9 [sqld] 노랭이책(개정판) - 44번 문제(p.58) 1. 예제 테이블col OSNAME for a30col DEVICENAME for a30col CUSTOMERNAME for a30SELECT * FROM OS;SELECT * FROM Device;SELECT * FROM Customer;-- OS 테이블 OSID OSNAME---------- ------------------------------ 100 Android 200 iOS 300 Bada -- 단말기 테이블 DEVICEID DEVICENAME OSID---------- ------------------------------ ---------- 1000 A1000 .. 2024. 8. 23. [sqld] 노랭이책(개정판) - 55번 문제(p.68) 1. 예제 테이블col SERVICENAME for a30col SERVICEURL for a30SELECT * FROM Service;SELECT * FROM ServiceUsage; SERVICEID SERVICENAME SERVICEURL---------- ------------------------------ ------------------------------ 1 Streaming http://streaming.com 2 Gaming http://gaming.com 3 E-commerce http://e.. 2024. 8. 23. [sqld] 노랭이책(개정판) - 46번 문제(p.60) 1. 예제 테이블SELECT A, B, X.C, D, EFROM EMP X LEFT OUTER JOIN DEPT YON (X.C = Y.C); A B C D E---------- ---------- ---------- ---------- ---------- 3 d w 1 10 1 b w 1 10 5 y ySELECT A, B, X.C, D, EFROM EMP X FULL OUTER JOIN DEPT YON (X.C = Y.C); A.. 2024. 8. 23. [sqld] 노랭이책(개정판) - 60번 문제(p.73) 1. 예제 테이블SELECT C1, C2, C3FROM TAB1START WITH C2 IS NULLCONNECT BY PRIOR C1 = C2ORDER SIBLINGS BY C3 DESC; C1 C2 C3---------- ---------- ---------- 1 A 3 1 C 2 1 B 4 2 D 2. 조회순서A -> 1번│├── B -> 3번│ ││ ├── D -> 4번│└── C -> 2번SELECT C1, C2, C3, LEVELFROM TAB1START WITH C2 IS NULLCONNECT BY PRIOR C1 = C2ORDER .. 2024. 8. 22. [sqld] 노랭이책(개정판) - 57번 문제(p.70) 1. 예제 테이블 2. 문제 보기-- 1번SELECT b.grade, a.job, SUM(a.sal) AS SUM_SAL, COUNT(*) AS CNTFROM emp a, salgrade bWHERE a.sal BETWEEN b.losal AND b.hisal GROUP BY GROUPING SETS (grade, (job, grade)); GRADE JOB SUM_SAL CNT---------- -------------------------------------------------- ---------- ---------- 2 CLERK .. 2024. 8. 21. [sqld] 노랭이책(개정판) - 41번 문제(p.56) 1. 예제 테이블set lines 1000col CUSTOMER_NAME for a30SELECT * FROM CUSTOMER;SELECT CUSTOMER_ID, TO_CHAR(USAGE_TIME, 'YYYY-MM-DD HH24:MI:SS') AS USAGE_TIME, USAGE_AMOUNTFROM TIME_USAGE;SELECT TO_CHAR(START_TIME, 'YYYY-MM-DD HH24:MI:SS') AS START_TIME,TO_CHAR(END_TIME, 'YYYY-MM-DD HH24:MI:SS') AS END_TIME,RATE FROM TIME_SLOT;-- 고객 테이블CUSTOMER_ID CUSTOMER_NAME DATE_OF_B----------- -----.. 2024. 8. 21. 이전 1 2 다음
