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

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ÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿

mssqlÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿
ÓÐÖØ¸´µÄÊý¾Ý¾ÍÏÔʾһÌõÖØ¸´µÄÊý¾Ý£¬Ã»Öظ´µÄ²»ÏÔʾ£¬²éѯÓï¾ä¸ÃÔõÃ´Ð´ÄØ£¿Ð»Ð»

SQL code:
select distinct *
from tablename
where id in (
selec ......

²é¿´±¾»úMSSQLÁ¬½Ó³Ø£¬Ôõô²Ù×÷£¿Ð»Ð»

˵À´º¦Ðß¹þ£¬ºÇºÇ¡­¡­
×Ôѧ±à³ÌÒѾ­Á½Äê¶àÁË£¬»¹²»»á²é¿´Êý¾Ý¿âÁ¬½Ó³Ø°¡£¬Çë´óÏÀÃÇ˵һÏÂÔõÑù²é¿´Ñ½£¿

±È·½Ëµ£¬ÎÒÓÃIEºÍFFºÍOperaͬʱÒÔÈý¸öÓû§Éí·Ý´ò¿ª±¾µØÍøÕ¾£¨ÍøÕ¾ÔÚIISÉÏ£¬µØÖ·Èçhttp://127.0.0.1/M ......

phpÁ¬½Ómssql2000

php.iniÎÒÒѾ­ÉèÖúÃÁË¡£

¶øÇÒÎÒÒ²°Ñmssql.dll·Åµ½systemÀïÁË¡£

  Êý¾Ý¿âµÄÁ¬½Ó´úÂëҲûʲôÎÊÌâ¡£

includeºóûʲôÎÊÌâ¡£

µ«ÊÇÖ»ÒªÎÒ½¨Á¢¸öÊý¾Ý¿â¶ÔÏóÒÔºóÍøÒ³¾ÍÎÞ·¨ÏÔʾÁË¡£ ......

mssqlÓëmysql»¥·ÃÎÊÌâ

ÏÖÔÚ×÷Á˸öϵͳ,Êý¾Ý¿âʹÓÃmysql,µ«ÊÇÐèÒª´ÓÁíÒ»¸öMSSQLÖлñµÃһЩ»ù´¡Êý¾Ý,Çë½Ì¸÷λ,ÎÒÄܲ»ÄÜͨ¹ýÒ»ÖÖ·½Ê½»ñµÃÏ໥µÄÊý¾Ý,лл!
MS SQL server µ¹ÊÇ¿ÉÒÔÔÚÕâ¼ÜWINODWS ·þÎñÆ÷Éϰ²×°MYSQLµÄODBCÇý¶¯£¬È»ºó½øÐзÃÎÊ¡ ......

mssql ¸ß¼¶²éѯ

ÉÌÆ·±í
ProductManager_Name                  ProductManager_Type_Id
-------------------------------------------------------------
Öйú¾­¼ÃÈȵãÑо¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ