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
Ïà¹ØÎÊ´ð£º
mssql ÀïµÄsystem_user ÔÚoracleÀïÓÐʲôµÈ¼Ûº¯Êý£¿
system_userÊä³öÊǵÄʲô£¿
µ±Ç°²Ù×÷µÄÓû§£¬ÄãÓÃʲôµÇ¼SQL Query Analyzer ¾ÍÊÇʲô
²»Á˽âmsqsl£¬Õâ¸öº¯ÊýÊÇÈ¡µ±Ç°Á¬½ÓuserµÄÂð£¿
Èç¹ûÊǵϰ ......
ÈçÌ⣬Ï뽫ÎÒÒÔǰ×ö¹ýµÄÍøÕ¾·ÅÔÚÍøÉϸøÈË¿´£¬ÓÉÓÚÊÇms sqlµÄ£¬´ó¶àÊýÍøÂçÉ̵ÄÐéÄâÖ÷»úÊÇÒªÊշѵģ¬
Ïë´ò°üºó·ÅÔÚһЩÃâ·ÑµÄ¿Õ¼ä£¬ÈÃÈ˼Ò×Ô¼ºÏÂÔØÈ¥¿´£¬ËùÒÔÏ£Íû´ò¹ý°üºóµÄÊý¾Ý¿âµÄ±í²»Èÿͻ§¿´µ½£¬
»òÕßÊǼӹý ......
˵À´º¦Ðß¹þ£¬ºÇºÇ¡¡
×Ôѧ±à³ÌÒѾÁ½Äê¶àÁË£¬»¹²»»á²é¿´Êý¾Ý¿âÁ¬½Ó³Ø°¡£¬Çë´óÏÀÃÇ˵һÏÂÔõÑù²é¿´Ñ½£¿
±È·½Ëµ£¬ÎÒÓÃIEºÍFFºÍOperaͬʱÒÔÈý¸öÓû§Éí·Ý´ò¿ª±¾µØÍøÕ¾£¨ÍøÕ¾ÔÚIISÉÏ£¬µØÖ·Èçhttp://127.0.0.1/M ......
¼ÙÉèÓÐÁ½ÕÅ±í£¬t1 t2
t1:id ×Ö¶Î1 ×Ö¶Î2 ×Ö¶Î3
t2:id ×Ö¶Î4 ×Ö¶Î5 ×Ö¶Î6
ÏÖÓÃÒ»Ìõ²éѯÓï¾äselect t1.*,t2.* from t1,t2 where t1.id=t2.id and Ìõ¼þ¡¡
½«·ûºÏÌõ¼þµÄÊý¾Ý´ÓmssqlÊý¾Ý¿âÖе¼³öÖÁexce ......
ÏÖÔÚ×÷Á˸öϵͳ,Êý¾Ý¿âʹÓÃmysql,µ«ÊÇÐèÒª´ÓÁíÒ»¸öMSSQLÖлñµÃһЩ»ù´¡Êý¾Ý,Çë½Ì¸÷λ,ÎÒÄܲ»ÄÜͨ¹ýÒ»ÖÖ·½Ê½»ñµÃÏ໥µÄÊý¾Ý,лл!
MS SQL server µ¹ÊÇ¿ÉÒÔÔÚÕâ¼ÜWINODWS ·þÎñÆ÷Éϰ²×°MYSQLµÄODBCÇý¶¯£¬È»ºó½øÐзÃÎÊ¡ ......