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

Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý

Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Çóƽ¾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇƽ¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚƽ¾ùÖµ¸½½ü£¬¶øƽ¾ùֵΪ·½²îµÄƽ·½¸ù¡£
ÓÃÀ´ÃèÊöÊýÖµ¼¯ºÏ£¬¼ÆËãÓëËãÊõ¾ùÖµ»òƽ¾ùÖµÖ®¼äµÄ²îÒì¡£
SQLÓï¾äÖеĺ¯ÊýÊDz»·Ö´óСдµÄ¡£
1¡¢COUNT
»ñµÃ¼Ç¼Êý
ËÄÖÖÊý¾Ý¿â¶¼Ò»Ñù,Ó÷¨ÈçÏÂ:
COUNT (*) ·µ»ØÌõ¼þ²éѯ½á¹ûÖÐËùÓмǼµÄÊýÁ¿.
COUNT (ALL expression) ¶Ô×éÖеÄÿһÐж¼¼ÆËã expression ²¢·µ»Ø·Ç¿ÕÖµµÄÊýÁ¿¡£
COUNT (DISTINCT expression) ¶Ô×éÖеÄÿһÐж¼¼ÆËã expression ²¢·µ»ØΨһ·Ç¿ÕÖµµÄÊýÁ¿¡£
2¡¢AVG
ƽ¾ùÖµ
ËÄÖÖÊý¾Ý¿âµÄÓ÷¨Óе㲻һÑù.
AccessºÍMySQL²»Ö§³ÖAVG(distinct expression)²Ù×÷,¶øOracleºÍMS SQL ServerÊÇÖ§³ÖµÄ.
3¡¢MIN, MAX
·Ö±ð·µ»Ø±í´ïʽÖеÄ×îСºÍ×î´óÖµ
ËÄÖÖÊý¾Ý¿âÇø±ð¸úÉÏÃæAVGº¯ÊýÒ»Ñù.
4¡¢Sum
ÇóºÍ
Ó÷¨ÓÐÇø±ð,Ò²ÊÇAccessºÍMySQL²»Ö§³Ö´ødistinctµÄ±í´ïʽÓ÷¨.
5¡¢±ê׼ƫ²îº¯Êý:
ËÄÖÖÊý¾Ý¿âµÄ²î±ð¸ü´óÁË,ÔںܶàµØ·½Ò²ÊDz»ÏàͬµÄ£º
²úÆ·
×ÜÌåÆ«²î
³éÑùÆ«²î
Ó÷¨
˵Ã÷
Access
StDevP()
StDev()
À¨ºÅÖÐÓÃ×Ö¶ÎÃû»òÕß×Ö¶ÎÔËËã±í´ïʽ
²»Ö§³Ö±í´ïʽǰ¼Ódistinct,PÊÇPopulation¡£
MS SQL Server
ͬÉÏ
ͬÉÏ
ͬÉÏ
Ö§³Ö±í´ïʽǰ¼Ódistinct
Oracle
StdDev_Pop()
StdDev()
StdDev_Samp()
ͬÉÏ
Ö§³Ö±í´ïʽǰ¼Ódistinct
MySQL
5.0.3°æÒÔÇ°
Std()
StdDev()
5.0.3°æÒÔºó,¼ÓÈëSTDDEV_POP()
5.0.3°æÒÔÇ°
ÎÞ
5.0.3°æÒÔºó¼ÓÈëSTDDEV_SAMP()
ͬÉÏ
²»Ö§³Ö±í´ïʽǰ¼Ódistinct
6¡¢·½²îº¯Êý:
²úÆ·
×ÜÌåÆ«²î
³éÑùÆ«²î
Ó÷¨
˵Ã÷
Access
VarP()
Var()
À¨ºÅÖÐÓÃ×Ö¶ÎÃû»òÕß×Ö¶ÎÔËËã±í´ïʽ
²»Ö§³Ö±í´ïʽǰ¼Ódistinct
MS SQL Server
ͬÉÏ
ͬÉÏ
ͬÉÏ
Ö§³Ö±í´ïʽǰ¼Ódistinct
Oracle
Var_pop()
var_samp()
variance
ͬÉÏ
Ö§³Ö±í´ïʽǰ¼Ódistinct
MySQL
4.1°æÒÔÇ°
ûÓÐ
5.0.3°æÒÔºó,¼ÓÈëVAR_POP()
5.0.3°æÒÔÇ°
ÎÞ
5.0.3°æÒÔºó¼ÓÈëVAR_SAMP()
ͬÉÏ
²»Ö§³Ö±í´ïʽǰ¼Ódistinct
¡¡¡¡ÎªÁ˸ü¸ßЧµØ²Ù×÷Êý¾Ý¿â£¬ÎÒÃÇÍùÍù¶¼Òª½èÖúÓÚһЩ²Ù×÷¹¤¾ß¡£ÔÚAccessÖУ¬µ±È»¾ÍÊÇÆä±¾ÉíÁË£¬¶øÔÚSQL ServerÖУ¬¿ÉÒÔÓÃÆóÒµ¹ÜÀíÆ÷ºÍ²éѯ·ÖÎöÆ÷À´Íê³ÉÄãÏëÒªÍê³ÉµÄ¹¤×÷£¬¶ÔÓ


Ïà¹ØÎĵµ£º

oracle ÐÞ¸Ä×Ö¶ÎÀàÐ͵ķ½·¨

½ñÌ칫˾ÒòΪҵÎñÐèÒª,ÐÞÒªÐÞ¸Äij¸ö×Ö¶ÎÊý¾ÝÀàÐÍÓÐnumber(5),±äΪnumber(5,2)ÐÍ
ÒªÊÇûÓÐÊý¾ÝµÄ»°Ö±½ÓÓÃÒÔÏÂÓï¾ä¼´¿É
alter   table  tb_test  modify permile  number(5,2);
µ«ÊÇÓÐÊý¾ÝµÄ»° ¾Í²»ÄÜÓÃÉÏÃæ·½·¨ÁË,
alter table tb_test add permile_temp number(5,2)
update tb_test set  ......

Oracle 10G Êý¾Ý¿âÎļþĿ¼½á¹¹

ÔÚOracle Database 10gÖÐ,OracleµÄĿ¼½á¹¹ÊÇÓÉOracle_Base¼°Æä×ÓĿ¼Oracle_Home¡¢admin¡¢flash_recovery_areaºÍoradataĿ¼¹¹³ÉµÄ¡£Îª·½±ãÌÖÂÛ£¬ÓÃOracle_Base´ú±íOracleĿ¼Ê÷µÄ¸ù£¬ÓÃOracle_Home±íʾ¸ùĿ¼ÏµÄÖ÷Ŀ¼¡£
1.Oracle_BaseĿ¼
Oracle_Base´ú±íOracleĿ¼Ê÷µÄ¸ù¡£Èç¹ûʹÓÃOracle Universal Installer½øÐ ......

ʹÓÃoracle 10gÊý¾Ý¿â´´½¨½Å±¾ÊµÏÖÊÖ¶¯´´½¨Êý¾Ý¿â

×î½ü¹¤×÷ÉÔ΢±È½Ï¿ÕÏУ¬±ã°ÑʹÓÃDBCA ´´½¨Êý¾Ý¿âʱµÄÊä³öµÄ½Å±¾ÄÃÀ´Ñо¿Ñо¿£¬²¢²ÎÕսű¾Îļþ£¬ÊÖ¶¯ÊµÏÖÒ»¸öÊý¾Ý¿âµÄ´´½¨¹ý³Ì¡£Ê×ÏÈʹÓÃDBCA¹¤¾ß´´½¨Ò»·Ý½¨¿â½Å±¾£¬Õû¸ö½Å±¾Îļþ°üº¬ÈçÏÂÎļþ£¬
¸Ð¾õÓ¦¸ÃÊÇ´ÓBATÎļþ¿ªÊ¼ÈëÊÖ£¬´ò¿ªBATÎļþ²é¿´ÄÚÈÝÈçÏ£º
mkdir f:\oracle\product\10.2.0\admin\test\adump
mkdir f:\oracl ......

mysql½ûÖ¹Ô¶³ÌrootµÇ½ (ת)

½â¾ö·½·¨£º
1¡£ ¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
mysql -u root -pvmwaremysql>use mysql;
mysql>update ......

ÓÅ»¯MySQL²åÈë·½·¨µÄÎå¸öÃîÕÐ

Ô­ÎÄÁ´½Ó http://database.51cto.com/art/200904/117957.htm
ÒÔÏÂÊÇÉæ¼°µ½²åÈë±í¸ñµÄ²éѯµÄ5ÖָĽø·½·¨£º
1)ʹÓÃLOAD DATA INFILE´ÓÎı¾ÏÂÔØÊý¾ÝÕ⽫±ÈʹÓòåÈëÓï¾ä¿ì20±¶¡£
2)ʹÓôøÓжà¸öVALUESÁбíµÄINSERTÓï¾äÒ»´Î²åÈ뼸ÐÐÕ⽫±ÈʹÓÃÒ»¸öµ¥ÐвåÈëÓï¾ä¿ì¼¸±¶¡£µ÷Õûbulk_insert_buffer_size±äÁ¿Ò²ÄÜÌá¸ß£¨Ïò°üº¬Ðеıí ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ