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¸í·É¾î°¡ ¿Ã¹Ù¸£°Ô Á¾·áµÇÁö ¾Ê¾Ò´Ù°í ±×·¯³×¿ä-_- ÀÌ»óÇϳ×.. Ʋ¸®°Ô ÇÑ°Å ¾ø´Â°Å °°Àºµ¥--;; ´Ù¸¥ °Íµéµµ ¸î°³ Çغôµ¥ ¸í·É¾î°¡ ¿Ã¹Ù¸£°Ô Á¾·áµÇÁö ¾Ê¾Ò´Ù°í ±×·¯´Â°Ç..µµ´ëü ¿Ö ±×·¯´Â°Å¿¡¿ä?? |