mssql ¶à±í²éѯµÄÎÊÌâ
ÇëÎÊ£ºÔÚ¶à±í²éѯÖУ¬²éѯ²»Í¬±íÖеĶà¸ö×ֶΣ¬ÆäÖÐÓÐЩ×ֶΰüÀ¨º¯Êý£¬¶àл¸÷λ´óÏÀÖ¸µãÃÔ½ò°¡£¡£¡£¡
±í1
¹¤ºÅ ÐÕÃû
1 Ëν
2 ¬¿¡Òå
±í2
¹¤ºÅ µÃ·Ö ÆÚÊý
1 50 1
1 60 2
1 64 3
²éѯ½á¹û
ÐÕÃû µÃ·Ö£¨ÈýÆÚµÄavg£©
Ëν 58
SQL code:
select ÐÕÃû,µÃ·Ö=avg(µÃ·Ö) from ±í1 A,±í2 B where A.¹¤ºÅ=B.¹¤ºÅ
group by ÐÕÃû
SQL code:
select ÐÕÃû,avg(µÃ·Ö) as µÃ·Ö
from ±í1 inner join ±í2 on ±í1.¹¤ºÅ=±í2.¹¤ºÅ
group by ÐÕÃû
SQL code:
select a.¹¤ºÅ,a.ÐÕÃû,µÃ·Ö=avg(b.µÃ·Ö)
from ±íÒ» a inner join ±í¶þ b on a.¹¤ºÅ=b.¹¤ºÅ
group by a.¹¤ºÅ
SQL code:
1> select * from ±í1;
2> go
¹¤ºÅ |ÐÕÃû
-----------|----------
1|Ëν
2|¬¿¡Òå
(2 rows
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬Ï뽫ÎÒÒÔǰ×ö¹ýµÄÍøÕ¾·ÅÔÚÍøÉϸøÈË¿´£¬ÓÉÓÚÊÇms sqlµÄ£¬´ó¶àÊýÍøÂçÉ̵ÄÐéÄâÖ÷»úÊÇÒªÊշѵģ¬
Ïë´ò°üºó·ÅÔÚһЩÃâ·ÑµÄ¿Õ¼ä£¬ÈÃÈ˼Ò×Ô¼ºÏÂÔØÈ¥¿´£¬ËùÒÔÏ£Íû´ò¹ý°üºóµÄÊý¾Ý¿âµÄ±í²»Èÿͻ§¿´µ½£¬
»òÕßÊǼӹý ......
ÎÒÁ¬½ÓÁËÁ½¸öÊý¾Ý¿â£¬mssql£¬access
ÈçºÎÔÚͬһ¸ö°´Å¥Ï²Ù×÷Á½¸öÊý¾Ý¿âµÄ±í
±ÈÈ磬ÎÒͨ¹ý¸´ÔÓµÄsqlÓï¾ä´ÓmssqlÊý¾Ý¿â¶à¸ö±íÈ¡µÃÁËÊý¾Ý
È»ºó²åÈëaccessÊý¾Ý¿âijһ¸ö±íÖÐ
SQL code:
SQL SER ......
Èç¹ûÓÃ×Ô¶¯Ôö³¤ÁÐ.»á³öÏÖµ±²åÈëÒì³£Ê±ÌøºÅ
ËùÒÔ²»µÃ²»Óô洢¹ý³Ì
±íÃû qfjh_bocai_dlt
Ö÷¼ü qishu
ÈÃqishu´Ó1¿ªÊ¼µÝÔö,Ò»¶¨Òª±£³ÖÁ¬ÐøÐÔ ²»´æÔÚÌøºÅÏÖÏó
..²»ÊǰÉ.ûÈË»áдÂð¡£
ÕâÕâÑù×ö£¬ ......
ÏÖÔÚ×÷Á˸öϵͳ,Êý¾Ý¿âʹÓÃmysql,µ«ÊÇÐèÒª´ÓÁíÒ»¸öMSSQLÖлñµÃһЩ»ù´¡Êý¾Ý,Çë½Ì¸÷λ,ÎÒÄܲ»ÄÜͨ¹ýÒ»ÖÖ·½Ê½»ñµÃÏ໥µÄÊý¾Ý,лл!
MS SQL server µ¹ÊÇ¿ÉÒÔÔÚÕâ¼ÜWINODWS ·þÎñÆ÷Éϰ²×°MYSQLµÄODBCÇý¶¯£¬È»ºó½øÐзÃÎÊ¡ ......
ÎÒµÄÓï¾äÈçÏ£º
$myServer = "124.172.125.197"; //Ö÷»ú
$myUser = "jmkjxy"; //Óû§Ãû
$myPass = "jmkjxy023"; //ÃÜÂë
$myDB = "jmkjxy"; //MSSQL¿âÃû ......