²»ÖªµÀ臨時±íÓÐ沒ÓÐÏÞÖÆÖ®類µÄ?
ÎÒÏëÍù臨時±íÖвå數據£¬µ«這個數據ºÜ´ó£¬¿ÉÄÜÓÐÉÏ億條£¬²»ÖªµÀ會²»會³¬³öÏÞÖÆ£¿
ÁíÍâ臨時±íÒ»°ã²»³¬過¶àÉÙ條£¬»òÕß²»³¬過¶à´ó±È較ºÃ£¿
ÀíÂÛÉ ......
ÓÐ×Ö¶Î
ÈÕÆÚ£¬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
......
»·¾³£º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¿ª·¢¹¤¾ßÖвéѯͬÑùµ ......
biz_id price
1 &nb ......
ÎʸöС°×ÎÊÌâ
Êý¾Ý¿âÀïÓÐÒ»ÕűíÊÇ´æ·Å²¿ÃÅÐÅÏ¢µÄ ÀïÃæ´æ·ÅÁË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´´½¨±í
ÎÒÊý¾Ý¿âÀïÓÉÒ»ÕÅTABLE±í£¬ÏÖÔÚÎÒÒªÒ»ÕÅTABLE1±í¡££¨×¢£ºÎÒËù½¨µÄTABLE1±íͨ¹ý¶Ô»°¿òÉϵÄÒ»±à¼¿òÊäÈ룬µã»÷°´Å¥ºóÒª½¨Á¢TABLE1±í£¬²¢ÇÒTABLE1±íÖеÄËùÓÐ×Ö¶ÎÊÇ´ÓTABLE±íÖжÁ³ö£¨³ýTABLE±íÖеĵÚÒ»¸öID×ֶΣ©Ò²¾ÍÊÇ˵TABLE1ÖеÄ×ֶκÍTABLEÖеÄÒ»Ñù³ýID×Ö¶ÎÍ⣩£¬Õâ¸öÎÊÌâÔõô½â¾ö ......