|
�젣 1怨쇰ぉ �뜲�씠�꽣踰좎씠�뒪
1. 愿�怨� �뜲�씠�꽣踰좎씠�뒪�뿉�꽌 main table�쓽 �뜲�씠�꽣瑜� �궘�젣�떆 媛� �쇅�옒�궎�뿉 ����엳 遺��빀�릺�뒗 紐⑤뱺
�뜲�씠�꽣瑜� �궘�젣�븯�뒗 李몄“ 臾닿껐�꽦�쓽 踰뺤튃���?
媛�. RESTRICTED
�굹. CASCADES
�떎. SET NULL
�씪. CUSTOMIZED
2. �떎�쓬 �몴��� 媛숈�� �꽦�쟻 �뀒�씠釉붿쓣 �씫�뼱 �븰�깮蹂� �젏�닔�룊洹좎쓣 �뼸怨좎옄 �븳�떎. 媛��옣 �븣留욎�� SQL 援щЦ���?
媛�. SELECT �꽦紐�, SUM(�젏�닔) FROM �꽦�쟻 ORDER BY �꽦紐�
�굹. SELECT �꽦紐�, AVG(�젏�닔) FROM �꽦�쟻 ORDER BY �꽦紐�
�떎. SELECT �꽦紐�, SUM(�젏�닔) FROM �꽦�쟻 GROUP BY �꽦紐�
�씪. SELECT �꽦紐�, AVG(�젏�닔) FROM �꽦�쟻 GROUP BY �꽦紐�
3. B-�듃由ъ뿉 ����븳 �꽕紐� 以� �삾吏� �븡��� 寃껋��?
媛�. �븳 �끂�뱶 �븞�뿉 �엳�뒗 �궥媛믩뱾��� �삤由꾩감�닚�쓣 �쑀吏��븳�떎.
�굹. �깘�깋, 異붽��, �궘�젣�뒗 猷⑦듃濡쒕���꽣 �떆�옉�븳�떎.
|
인 쇄
바로가기
1999�뀈 10�썡 10�씪�뿉 �떎�떆�맂 �젙蹂댁쿂由ш린�궗.hwp
[Size :
52 Kbyte
]
장바구니
