Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Äê¸ø 2 ת³ö 1 ±Ê 500Ôª
2009 1 3 1 100 Ϊ 1 µ¥Î» ÔÚ2009Äê¸ø 3 ת³ö 1 ±Ê 100Ôª
2009 1 4 3 200 Ϊ 1 µ¥Î» ÔÚ2009Äê¸ø 4 ת³ö 3 ±Ê 200Ôª
2009 2 1 2 100 Ϊ 2 µ¥Î» ÔÚ2009Äê¸ø 1 ת³ö 2 ±Ê 100Ôª
2009 4 1 1 100 Ϊ 4 µ¥Î» ÔÚ2009Äê¸ø 1 ת³ö 1 ±Ê 100Ôª
2009 3 1 2 100 Ϊ 3 µ¥Î» ÔÚ2009Äê¸ø 1 ת³ö 2 ±Ê 100Ôª
ÎÒÐèÒª²é³ö½á¹ûÈçÏÂ,²éѯ³ö2£¬3£¬4µ¥Î»¸ø1ת³öµÄ£¬ºÍÓÉ1תÈëµÄ£º
µ¥Î» ת³ö±ÊÊý ת³ö½ð¶î תÈë±ÊÊý ת³ö½ð¶î
id date outnum outamt innum inamt
2 2009 2 200 1 500
3 2009 2 100 1 100
4 2009 1 100 3 200
ÇëÎÊsqlÔõôд£¿
¶àл¡£¡£¡£¡£
select outid as id,date,sum(num),sum(amt)
from tb
where outid in (2,3,4) and inid =1]
group by outid,date
¿´ÔÎÁË,Êý¾ÝÊDz»ÊDz»¶Ô°¡
Ó¦¸ÃÊÇת¸ø1µÄºÍÓÉ1ת³öµÄ°É
Êý¾Ý²»¶Ô°¡
SQL code
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡
Óû§ÃûÊÇΨһµÄ
±íA ×Ö¶Î
Óû§Ãû£ºName ,ÓÊÏ䣺Ema ......