Çë½Ì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/
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔÎ µ ......