Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sql

sql 2005ÖеÄ臨時±í

²»ÖªµÀ臨時±íÓÐ沒ÓÐÏÞÖÆÖ®類µÄ?
ÎÒÏëÍù臨時±íÖвå數據£¬µ«這個數據ºÜ´ó£¬¿ÉÄÜÓÐÉÏ億條£¬²»ÖªµÀ會²»會³¬³öÏÞÖÆ£¿
ÁíÍâ臨時±íÒ»°ã²»³¬過¶àÉÙ條£¬»òÕß²»³¬過¶à´ó±È較ºÃ£¿
ÀíÂÛÉ ......

Çë½ÌÒ»¸ösqlÊý¾ÝɸѡÎÊÌâ

ÓÐ×Ö¶Î
ÈÕÆÚ£¬id

ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´

ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£
SQL code:
select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id)

SQL code:
select id,min(ÈÕÆÚ) from tb group by id

ÉÏÃæÁ½¸ö¶¼ÐÐ

ÒýÓÃ
ÓÐ×Ö¶Î
ÈÕÆÚ£¬id
......

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
2.ÔÚsql plusÖвéѯͬÑùµÄ±í£¬ÖÐÎÄÏÔʾÕýÈ·¡£
3.ÔÚpowerbulider¿ª·¢¹¤¾ßÖвéѯͬÑùµ ......

ÇóSQL½â¾öƽ¾ùÖµÓï¾ä

                    biz_id                   price
                      1           &nb ......

С°×ÎÊÌâ SQLÇ󯽾ùÖµ

ÎʸöС°×ÎÊÌâ 
Êý¾Ý¿âÀïÓÐÒ»ÕűíÊÇ´æ·Å²¿ÃÅÐÅÏ¢µÄ ÀïÃæ´æ·ÅÁË5¸ö²¿ÃÅ ÔõôÓÃSQLÓï¾äÇóÿ¸ö²¿ÃŵŤ×ÊÆ½¾ùÖµ
SQL code:
select ²¿ÃÅ,avg(¹¤×Ê) AS ƽ¾ù¹¤×Ê from ±í group by ²¿ÃÅ

SQL code:
select avg(¹¤資),²¿門 from tb group by ²¿門

SQL code:
select ²¿ÃÅ avg(¹¤×Ê) from ²¿ ......

VC+ado+sql´´½¨±í

¸÷λ´ó¼ÒºÃ
VC+ado+sql´´½¨±í

ÎÒÊý¾Ý¿âÀïÓÉÒ»ÕÅTABLE±í£¬ÏÖÔÚÎÒÒªÒ»ÕÅTABLE1±í¡££¨×¢£ºÎÒËù½¨µÄTABLE1±íͨ¹ý¶Ô»°¿òÉϵÄÒ»±à¼­¿òÊäÈ룬µã»÷°´Å¥ºóÒª½¨Á¢TABLE1±í£¬²¢ÇÒTABLE1±íÖеÄËùÓÐ×Ö¶ÎÊÇ´ÓTABLE±íÖжÁ³ö£¨³ýTABLE±íÖеĵÚÒ»¸öID×ֶΣ©Ò²¾ÍÊÇ˵TABLE1ÖеÄ×ֶκÍTABLEÖеÄÒ»Ñù³ýID×Ö¶ÎÍ⣩£¬Õâ¸öÎÊÌâÔõô½â¾ö ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [516] [517] [518] [519] 520 [521] [522] [523] [524] [525]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ