ÇóSQLÓï¾äÓÅ»¯¹¤¾ß£¿
ÇóSQLÓï¾äÓÅ»¯¹¤¾ß£¿
Õë¶ÔSQL ServerµÄ
·¢Ë͵½ÎÒÓÊÏäsclsmile@163.com
»òÕ߸øÎÒÒ»¸öÍøÖ·Á´½Ó
¹Ø×¢¡£
http://www.net130.com/class/oracle_datum_soft/Embarcadero%20SQLTuner%202.0.2.rar
http://space.itpub.net/?uid-16436858-action-viewspace-itemid-520854
http://www.net130.com/CMS/Pub/oracle/oracle_material/oracle_material_soft/173530.htm
ºÇºÇ,ÍøÕ¾ÉϵÄ,ûÓùý
»¹ÓÐÕ⹤¾ß,ËÓÐ?Ò²¸øÎÒÒ»¸ö.
ºÇºÇ
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
ÒªÊäÈëUSE <Êý¾Ý¿âÃû>ʱ£¬ÒªÓõ½SQL±à¼Æ÷£¬µ«²»ÖªµÀÔÚʲôµØ·½£¬¸ßÊÖ°ï°ïæѽ£¡
SQL2005 µã»÷ÓÒÉϽǵÄ--н¨²éѯ(N)
Êó標選擇Òª²é詢µÄ數據庫£¬È»á ......
ÏÈÀ´Ò»¸ö´íÎóÓï¾ä¡£¡£
select * from [aa] where a1 in (select max(a2),a1 from [aa] group by a1 )
ÎÒ´óÌåÒâ˼£¬
¶Áȡһ¸öͳ¼ÆÏµÍ³ÖÐ ²»Öظ´µÄ IP °´ÕÕ ×îºóʱ¼äÅÅÐò£¬²¢ÏÔʾ³öËùÓÐ×ֶΡ£¡ ......
±íA
¿¨ºÅ ʱ¼ä
1 null
2 null
3 & ......