µ¥ÀÌŸº£À̽º 2¹Ý °Ô½ÃÆÇ
(http://bi.snu.ac.kr/~skim/lecture/db02)

November 10, 2002 (22:32) from 211.212.111.251
Written by Çлý Hits : 989 , Lines : 13
help me~!
select max(tot_balance)
from (select branch_name,sum(balance)
     from account
     group by branch_name)as branch_total(branch_name,tot_balance)

==>ÀÌ°Å 156ÂÊ¿¡ Àִ°ǵ¥¿ä.
ÂÍ ±ä°Å Çѹø Çغ¼·Á°í °Ü¿ì ŸÀÌÇÎÇؼ­ ½ÇÇà½ÃÄ×´õ´Ï.
ÀÚ²Ù 4Çà¿¡ SQL¸í·É¾î°¡ ¿Ã¹Ù¸£°Ô Á¾·áµÇÁö ¾Ê¾Ò´Ù°í ±×·¯³×¿ä-_-
ÀÌ»óÇϳ×..
Ʋ¸®°Ô ÇÑ°Å ¾ø´Â°Å °°Àºµ¥--;;

´Ù¸¥ °Íµéµµ ¸î°³ Çغôµ¥ ¸í·É¾î°¡ ¿Ã¹Ù¸£°Ô Á¾·áµÇÁö ¾Ê¾Ò´Ù°í ±×·¯´Â°Ç..µµ´ëü ¿Ö ±×·¯´Â°Å¿¡¿ä??

Modify Delete Post Reply Backward Forward List