November 26, 2002 (13:16) from 203.255.190.41 | |
Written by .. | Hits : 836 , Lines : 30 |
4Àå Áú¹®¿ä.. ¾Æ¹«³ª ´ë´äÇØ ÁÖ¼¼¿ä. |
---|
4Àå¼ Áú¹®Àä. ³Ñ ±âÃÊÀûÀΰ͵µ ¾Ï°Íµµ ¸ð¸£°Ú³×¿©-.¤Ì;; Test for Empty Relation ¿¡¼ exists ¾²´Â°Å ³ª¿À°í¿ä ±× ´ÙÀ½¿¡ ¿¹Á¦·Î where not exists ¾²´Â°Å ³ª¿ÀÀÝ¾Æ¿ä ±×°Å ÀÌÇØ°¡ ¾È °¡¿ä. ¼³¸í Á¡ ´Ù½Ã ÇØ ÁÖ¼¼¿ä ±× nested µÈ ºÎºÐÀÌ ¸ðÇϴ°ÇÁö? ±×¸®°í¿ä ¸¸¾à account¸¦ °®°í ÀÖ´Â ¸ðµç °í°´À» À̸§À» Ãâ·ÂÇ϶ó¸é 1. select customer-name from depositor ¶ó°í¸¸ ÇÏ¸é ¾È µÇ°í ¿Ö account¿¡ account-number°¡ ÀÖ´ÂÁö °°ÀÌ È®ÀÎÀ» ÇؾßÇϳª¿ä?? 2. select customer-name from depositor, account where account.account_number=depositer.account_numer ÀÌ·¸°Ô ÇÏ´Â°Ô ¸ÂÁÒ? Depositor relationÀ» ¸¸Á·ÇÏ´Â »ç¶÷ÀÌ¸é ´ç¿¬È÷ account°¡ ÀÖÁö ¾ÊÀ»±î¿ä? |