Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇòÒ»¾ä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±í


ÒýÓÃ
SQL code
DECLARE @t TABLE (id int,income int)
INSERT INTO @t
SELECT 1 ,120
UNION ALL SELECT 2, 211
UNION ALL SELECT 3 ,116


SELECT b.id,
(SELECT SUM(a.income) from @t a WHERE a.id<=b.id¡­¡­


ÓαêÒ²¿ÉÒÔ£¬²»¹ýÂ¥Éϵĸü¼ò½àµã¡£

ÒýÓÃ
SQL code
DECLARE @t TABLE (id int,income int)
INSERT INTO @t
SELECT 1 ,120
UNION ALL SELECT 2, 211
UNION ALL SELECT 3 ,116


SELECT b.id,
(SELECT SUM(a.income) from @t a WHERE a.id<=b.id¡­¡­


ѧϰ¡­¡­

¹þ¹þ£¬Ã÷°×ÁË

¶ÔÁË£¬ÄÇselect * from aÈçºÎ¸³¸ø@tĨŶ£¡

Çë½ÌLZ
¿É²»¿ÉÒÔ¸øÎÒÉÔ΢½²Ò»ÏÂ
¡°SELECT b.id, 
  (SELECT SUM(a.income) from @t a


Ïà¹ØÎÊ´ð£º

js¿ØÖÆasp¿Õ¼ädropdownlist - .NET¼¼Êõ / ASP.NET

ÎÒÓÐÁ½¸ödropdownlist¶¼°óºÃÁËÖµ£¬ÏëÑ¡ÖÐÒ»¸ödropdownlistÖеÄÖµ£¬È»ºóÔÚÁíÒ»¸ödropdownlistÖÐÑ¡ÖÐÏàÓ¦µÄÒ»Ïî¡£
²»ÊÇ´Óа󶨵ڶþ¸ödropdownlist£¬ÊÇÔÚÒѾ­°óºÃµÄÖµµ±ÖÐÑ¡ÖÐÒ»¸ö¡£
ÎÒÏëÓÃjsд
ÇóÖú
Äã¿ÉÒÔ°Ñdrop ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......

C# SQL µÄUPDATETEXT ÎÊÌâ - .NET¼¼Êõ / C#

A±í ÓÐÁ½¸ö×ֶΠ
  id ΨһÊý×ÖÓò
  InfoTxt text ÀàÐÍ
 ÎÒÏÖÔÚÒª°Ñ id ²»ÊÇ14 µÄËùÓÐ InfoTxt×Ö¶Î Îı¾ºóÃæ ¶¼¼ÓÉÏ 'aaa' 
°´ÏÂÃæÖ´ÐÐÏÂÀ´ Ö»Óбí×îºóÒ»ÐмÓÉÏÁË 'aaa' ......

Accessͨ¹ýSqlÓï¾ä´´½¨Êý¾Ý¿â - .NET¼¼Êõ / C#

ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
  C=ID T="INTEGER" P=No M=No N="±àºÅ" Z=false,
  C=Ques ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ