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

sql²éѯתÖÃ

±í½á¹¹£º
¹ºÎïÈË          ÉÌÆ·Ãû³Æ      ÊýÁ¿
A                ¼×            2
B                ÒÒ            4
C                ±û            1
A                ÒÒ            2
B                ±û            5 


ͨ¹ý²éѯµÃµ½£º

¹ºÎïÈË    ¼×      ÒÒ      ±û
A          2        2      null
B          null    4      5
C          null    null    1
select  ¹ºÎïÈË,  decode( ÉÌÆ·Ãû³Æ ,'¼×' , ÊýÁ¿,null) ,
decode( ÉÌÆ·Ãû³Æ ,'ÒÒ', ÊýÁ¿,null) ,
decode( ÉÌÆ·Ãû³Æ ,'±û' , ÊýÁ¿,null)
from tab


http://topic.csdn.net/u/20100109/13/6a10c168-f190-4766-b838-adbf03c4ac7b.html?64992


select  ¹ºÎïÈË,  decode( ÉÌÆ·Ãû³Æ ,'¼×' , ÊýÁ¿,null) ,
decode( ÉÌÆ·Ãû³Æ ,'ÒÒ', ÊýÁ¿,null) ,
dec


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

Á½¾äSQL²¢Ò»¾ä,ÓÐÎÊÌâ. - MS-SQL Server / »ù´¡Àà

µÚÒ»¾ä:
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm 
 join jh on ht.htbh=jh.hth 
and ht.htbh not like'del%' and ht. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ