ÇòÒ»¾äsql - .NET¼¼Êõ / ASP.NET
table A
id income
1 120
2 211
3 116
........
table sum
id total
1 120 --1
2 331 --1+2
3 447 --1+2+3
........
ÈçºÎ°´Ìì»ã×ÜÒÔÀ´µÄÊÕÈ룬sqlÔõôд
select sum(Income) from Table
where Date between StartDate and EndDate
§Ö÷±íÊö²»Çå³þ°¡¡£¡£¡£¡£¡£¡£ÉÏÃæµÄ¾ÍÊÇsumÁË£¬×Ô¼º¸ãÇå³þÁ˺ܺÃдµÄ£¬ÎÞ·ÇÊÇgroup byºÍinner joinÖ®ÀàµÄ¡£¡£¡£
1 120
2 331
3 447
Õâ¸öÊǸù¾Ýtable A Êä³öµÄsum±í
ÓαêÒ²¿ÉÒÔ£¬²»¹ýÂ¥Éϵĸü¼ò½àµã¡£
ѧϰ¡¡
¹þ¹þ£¬Ã÷°×ÁË
¶ÔÁË£¬ÄÇselect * from aÈçºÎ¸³¸ø@tĨŶ£¡
Çë½ÌLZ
¿É²»¿ÉÒÔ¸øÎÒÉÔ΢½²Ò»ÏÂ
¡°SELECT b.id,
(SELECT SUM(a.income) from @t a
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÁ½¸ödropdownlist¶¼°óºÃÁËÖµ£¬ÏëÑ¡ÖÐÒ»¸ödropdownlistÖеÄÖµ£¬È»ºóÔÚÁíÒ»¸ödropdownlistÖÐÑ¡ÖÐÏàÓ¦µÄÒ»Ïî¡£
²»ÊÇ´Óа󶨵ڶþ¸ödropdownlist£¬ÊÇÔÚÒѾ°óºÃµÄÖµµ±ÖÐÑ¡ÖÐÒ»¸ö¡£
ÎÒÏëÓÃjsд
ÇóÖú
Äã¿ÉÒÔ°Ñdrop ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
A±í ÓÐÁ½¸ö×Ö¶Î
id ΨһÊý×ÖÓò
InfoTxt text ÀàÐÍ
ÎÒÏÖÔÚÒª°Ñ id ²»ÊÇ14 µÄËùÓÐ InfoTxt×Ö¶Î Îı¾ºóÃæ ¶¼¼ÓÉÏ 'aaa'
°´ÏÂÃæÖ´ÐÐÏÂÀ´ Ö»Óбí×îºóÒ»ÐмÓÉÏÁË 'aaa' ......
ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
C=ID T="INTEGER" P=No M=No N="񅧏" Z=false,
C=Ques ......