JAKARTAPROJECT
JAKARTA TIPJSP TIPJSP Áú¹®&´äº¯DATABASE TIPJAVASCRIPT TIPWEBHACKING TIP±âŸ TIP
À⵿»ç´Ï ÆÁ
À⵿»ç´Ï ÆÁ
¾Ë°í°Ô½Å ¿©·¯°¡Áö ÆÁµéÀ» ¿Ã·ÁÁÖ¼¼¿ä
MicroStrategy (MSTR) ¿ë¾î
GoodBug http://www.jakartaproject.com
À̹ÌÁö ½½¶óÀÌ´õ º¸±â

MicroStrategy (MSTR) ¿ë¾î

 

SELECT STORE_CD AS Á¡, COUNT(SALE_KEY) AS ¸ÅÃâ°Ç¼ö, SUM(SALE_AMT) AS  ¸ÅÃâ¾×

FROM SALE_MASTER

WHERE SALE_DATE BETWEEN '20070101' AND '20070131'

GROUP BY STORE_CD

 

 

¸ÅÆ®¸¯ : COUNT(SALE_KEY)  AS ¸ÅÃâ°Ç¼ö, SUM(SALE_AMT) AS ¸ÅÃâ¾×

ÆÑÆ® : SALE_KEY, SALE_AMT

¾îÆ®¸®ºäÆ® : STORE_CD AS Á¡ (GROUP BY)

ÇÊÅÍ : SALE_DATE

 

2007-11-28 11:04:52
211.189.124.***

 

ÁÁÀº»ý°¢ ^^

0Á¡ (0¸í)
µ¡±Û 0°³ | ÅÂ±× 1°³ | °ü·Ã±Ûº¸±â
ű×ÀÔ·Â
½±Ç¥(,)±¸ºÐÀ¸·Î Çѹø¿¡ ¿©·¯ ű׸¦ ÀÔ·ÂÇÒ¼ö ÀÖ½À´Ï´Ù
MSTR (1)
À̸§ ºñ¹Ð¹øÈ£
À⵿»ç´Ï ÆÁ
¾Ë°í°Ô½Å ¿©·¯°¡Áö ÆÁµéÀ» ¿Ã·ÁÁÖ¼¼¿ä
! ¹øÈ£ Á¦¸ñ ±Û¾´ÀÌ ÀÏÀÚ Á¶È¸
±âŸ ÅøÀ̳ª ½Ã½ºÅÛ¿¡ °ü·ÃµÈ TIP °Ô½ÃÆÇ ÀÔ´Ï´Ù GoodBug 2005-04-22 5,789
73 ÁÁÀº·¹Æ÷Æ® ¾²±â kaiser 2009-01-01 6,090
72 ÀÌŬ¸³½º ½ÇÇට ¿¡·¯³ª´Â °Í ÇØ°á¹æ¹ý-Eclipse Ganymede kaiser 2008-10-21 6,811
71 CPU °³¼ö È®ÀÎ ¸í·É¾î kaiser 2008-06-17 7,941
70 svmon svmon ¸í·É¾î 1 GoodBug 2008-04-11 6,970
69 find grep find ¿¡ Á¤±Ô½Ä Æ÷ÇÔÇÑ ¿¹Á¦ 1 kaiser 2008-04-08 10,405
68 UNIX¿¡¼­ ³¯Â¥ °¡Á®¿À±â lkwww 2008-01-29 9,977
67 °³Ç๮ÀÚ ½Ã½ºÅÛº° °³Ç๮ÀÚ 1 GoodBug 2008-01-07 8,581
66 JDBC ¿À¶óŬ¿¡¼­ jdbc µå¶óÀ̹ö¸¦ 10g ÀÌ»ó »ç¿ëÇ϶ó°í Çϳ׿ä 1 1 kaiser 2008-01-03 8,286
65 java¿¡¼­ properties È°¿ë °¡ÀÌµå ¶óÀÎ kaiser 2007-12-21 10,565
MSTR MicroStrategy (MSTR) ¿ë¾î 1 GoodBug 2007-11-28 7,676
63 svn À©µµ¿ì¿ë Subvision ¼³Ä¡¿Í È°¿ë(v1.4.5) with subclipse ÃÊ°£´Ü ¹öÀü 2 2 pearlÁþ°Å¸® Àü¹® 2007-11-16 7,226
62 port Unix ½Ã½ºÅÛ Æ÷Æ®¹øÈ£ 2 GoodBug 2007-11-16 6,064
61 MIME MIME ŸÀÔ ÃÑÁ¤¸® 1 GoodBug 2007-10-27 6,807
60 ½© ½ºÅ©¸³Æ® ÆÄÀÏ½Ä GoodBug 2007-09-07 6,955
59 Å͹̳μ­ºñ½º Å͹̳μ­ºñ½º ¿ø°Ý Á¢¼Ó ·Î±× È®ÀÎÇÏ´Â ¹æ¹ý 1 GoodBug 2007-08-20 17,718
58 unix DBA°¡ ¾Ë¾Æ¾ß ÇÏ´Â À¯´Ð½º ¸í·É¾î 1 kaiser 2007-02-28 6,785
57 shell ¼ö ºñ±³ GoodBug 2007-01-09 5,548
56 ³×Æ®¿öÅ© µå¶óÀ̺ê dos¿¡¼­ Àâ´Â ¹æ¹ý kaiser 2006-11-09 7,886
55 windows xp ½ÃµðÅ° º¯°æ 1 kaiser 2006-11-08 10,896
copyright 2005-2024 by Unicorn