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

SQLÖмÆËãÊý¾ÝºÍ

ÓÐÒ»×éÊý¾ÝÈçÏÂ:
------------------
  ID      Ö§³ö
  1        10
  2        -2
  3        16
  4        -8
------------------
Total      16

Çë½Ì¸÷λ: Ôõô²ÅÄܼÆËã³ö"Ö§³ö"ÁеÄ×ÜÊý?

лл!

Èç¹ûÒªÇóÖ§³öÁ˶àÉÙ
¿ÉÒÔ Óà ÈçÏÂÓï¾äSQL code:
Select sum(Ö§³ö) as ×ÜÖ§³ö from table
ÔËÐнá¹ûΪ16

ͬÒâÂ¥ÉϵÄ×ö·¨

ÒýÓÃ
ÓÐÒ»×éÊý¾ÝÈçÏÂ:
------------------
  ID      Ö§³ö
  1        10
  2        -2
  3        16
  4        -8
------------------
Total      16

Çë½Ì¸÷λ: Ôõô²ÅÄܼÆËã³ö"Ö§³ö"ÁеÄ×ÜÊý?

лл!
select sum(Ö§³ö) from tb

´Õ¸öÈÈÄÖ
select sum(Ö§³ö) as Ö§³Ö×ܶî from tb

Ò»¸ö×êʯ¼¶£¬Ò»¸öËÄÐǼ¶ ºÍÎÒÕâÁ½¸öÈý½ÇµÄÇÀ·Ö£¬ÑÏÖØ±ÉÊÓ¡£

select sum(Ö§³ö) as Ö§³Ö×ܶî from tb
¾ÛºÏº¯Êý£¬LSµÄ±ðÕâÑù£¬Èç¹ûÄãÖ»ÊÇΪÁ˵÷־Íû±ØÒªÁË£¬ÎÒJAVA¿éµÃÁË¿ì2000·Ö£¬ºÜ¾Ã¶¼Ã»ÓÃËü£¬Ã»µÃÒâ˼£¬

ÒýÓÃ


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

¹ØÓÚSQLµÄÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

Id Name Flag
1 ÕÅÈý 1  
2 ÍõÎå 3
3 ÕÅÈý 1
4 ÀîËÄ 2
5 ÕÅÈý 1
6 ÀîËÄ 2
ÎÒÏëÊä³öµÄʱºò±ä³ÉÕâÑù
Id Name Flag
1 ÕÅÈý 1 & ......

sql´æ´¢¹ý³Ìʱ¼äÏà¼õ - .NET¼¼Êõ / ASP.NET

CREATE PROCEDURE [selectvipcompany] 
@username varchar(50), 
@companyname varchar(50), 
@endtime varchar(1) 
AS 
declare @sql varchar(1000) 
set @sql=''  ......

sql server - Java / Eclipse

Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....

ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡

½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ