Çë½Ì¹ØÓÚ2¸öSQLµÄ±È½Ï
select * from a,b where a.city="±±¾©" and b.city="±±¾©" select * from a,b where b.city=a.city and a.city="±±¾©" ÄǸö¸ü¿ì£¿ Ï£ÍûÄÜ˵³öÔÒò¡£Ð»Ð»
±í½á¹¹Ò»ÑùµÄ»°£¬ÕâÁ©Óï¾äÓ¦¸ÃÊǵȼ۵ġ£ ¿´¿´Ö´Ðмƻ®¡£ ¼ÇµÃORACLE¶ÔÕâÑùµÄ´¦Àí»úÖÆÊÇÒ»ÑùµÄ,¿ÉÒÔ¿´×÷¶¼ÊÇÈ·¶¨µÄÖµ,¶ø²»½øÐйØÁªÒýÓà ¼ÇµÃORACLE¶ÔÕâÑùµÄ´¦Àí»úÖÆÊÇÒ»ÑùµÄ,¿ÉÒÔ¿´×÷¶¼ÊÇÈ·¶¨µÄÖµ,¶ø²»½øÐйØÁª ÄÇÕâô˵£¬ÊǵÚÒ»¾äµÄЧÂÊÒª¸ßÂ Ò»ÑùµÄÒýÓà ÒýÓà 3 Â¥ huntian8 µÄ»Ø¸´:ÒýÓà 2 Â¥ java3344520 µÄ»Ø¸´:¼ÇµÃORACLE¶ÔÕâÑùµÄ´¦Àí»úÖÆÊÇÒ»ÑùµÄ,¿ÉÒÔ¿´×÷¶¼ÊÇÈ·¶¨µÄÖµ,¶ø²»½øÐйØÁª ÄÇÕâô˵£¬ÊǵÚÒ»¾äµÄЧÂÊÒª¸ßÂ Ôε¹°¡,ÄãÈ¥¿´¿´ORACLEµÄ´¦Àí»úÖÆ,ÎÒÍü¼ÇÔÚÄÄÀï¿´µ½,ORACLEÓкü¸ÖÖËÑË÷»úÖÆ,ÓнéÉÜ ÄÇÄãµÄÒâ˼ÊÇÄĸöЧÂʸߣ¿»¹ÊÇÒ»Ñù¸ß£¿ Ò»Ñù........ µÈ´ýÄǸöOracle´óÅ£½â¾ö£¡£¡
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬ »òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡ ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡 ֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡ °ïUP ²Î¿¼:http://hi.baidu.com/toiota ......
¹ØÓÚSQL Server Mobile Edition ÓÃMicrosoft SQL Server2005 Management Studio Express9.00.3042.00´´½¨SQLCEÊý¾Ý¿âsqlmobile.sdf ÔÚmobileϵͳÖÕ¶ËÉÏÓÃSQL Server Mobile Edition3.0Äܲ鿴sqlmobile.sdfÀï±íÊý¾Ý ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID 1,Name1....test1,1,99 1,Name1....test1,3,99 1,Name2....test2,1,101 1,Name2....test2,3,101 1,Name3....test3,2,101 1,Name1....test1,4,101 ÏëÒªµÄ½á¹ûÊÇ: 1,Na ......