ÇóSQL severe 2000ÊÔÌâ¡£ - MS-SQL Server / »ù´¡Àà
ѧSQL SERVER 2000 Ò²ÓÐ10ÌìÁË¡£Ïë¸ãµãÌâÄ¿À´×Ô¼º×ö×ö¡£¿´¿´×Ô¼ºË®Æ½~£¡£¡£¡
¸ÕÈëÃÅ~£¡£¡£¡£¡£¡ SQL code: ´æÔÚÈçÏÂ3Õűí S£¨Ñ§ºÅ£¨SNO)PK,ÐÕÃû£¨SNAME))£» C£¨±àºÅ£¨CNO)PK,Ãû³Æ(CNAME),½Ìʦ£¨CTEACHER); SC((ѧºÅ£¨SNO)FK,¿Î³Ì±àºÅ£¨CNO)FK)PK,³É¼¨£¨SCGRADE)); ÊÔÍê³ÉÒÔϲéѯ¹¦ÄÜ ÎÊÌâ1¡¢ÕÒ³öѧ¹ý¡°1¡±ºÅ¿Î³ÌµÄѧÉúÐÕÃûºÍ³É¼¨ 2¡¢ÕÒ³öûÓб¨¡°ÀîÃ÷¡±ÀÏʦµÄѧÉúµÄÐÕÃû 3¡¢Áгöÿ¸öѧÉúµÄƽ¾ù³É¼¨ºÍÐÕÃû 4¡¢ÁгöÓÐ2ÃÅÒÔÉÏ£¨º¬2ÃÅ£©¿Î³Ì²»¼°¸ñµÄѧÉúµÄÐÕÃû 5¡¢Áгöѧ¹ý¡°1¡±£¬¡°2¡±ºÅ¿Î³Ì³É¼¨µÄѧÉúµÄÐÕÃû 6¡¢Áгö¡°1¡±ºÅ¿Î³Ì³É¼¨¸ßÓÚ¡°2¡±ºÅ¿Î³Ì³É¼¨µÄѧÉú 7¡¢Áгö¡°1¡±ºÅ¿Î³Ì³É¼¨¸ßÓÚ¡°2¡±ºÅ¿Î³Ì³É¼¨µÄѧÉúµÄÐÕÃû£¬¡°1¡±ºÅ¿Î³Ì³É¼¨£¬¡°2¡±ºÅ¿Î³Ì³É¼¨ºÍÁ½ÃÅ¿ÎµÄÆ½¾ù³É¼¨ Õâ¸öÂÛ̳¾ÍºÜ²»´íÀ²£¡ÎÒÔÚÕâÀï´ýÁËÓÐ n ÌìÁË....ÒýÓà SQL code ´æÔÚÈçÏÂ3Õűí S£¨Ñ§ºÅ£¨SNO)PK,ÐÕÃû£¨SNAME))£» C£¨±àºÅ£¨CNO)PK,Ãû³Æ(CNAME),½Ìʦ£¨CTEACHER); SC((ѧºÅ£¨SNO)FK,¿Î³Ì±àºÅ£¨CNO)FK)PK,³É¼¨£¨SCGRADE)); ÊÔÍê³ÉÒÔϲéѯ¹¦ÄÜ ÎÊÌâ1¡¢ÕÒ³öѧ¹ý¡°1¡±ºÅ¿Î³ÌµÄѧÉúÐÕÃûºÍ³É¼¨ 2¡¢ÕÒ³öûÓб¨¡°ÀîÃ÷¡±ÀÏʦµÄѧÉúµÄÐÕÃû 3¡¢Áгöÿ¸öѧÉúµÄƽ¾ù¡¡ ллÁË¡£¡£¡£ ÕâÖеÄ×ö¹ýÀàËÆµÄÁË¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£© tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname ½á¹û£º µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£ MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10. ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏ ±íÃû: hisdata ×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä Id value state dattime 101 32.3 0 ......
Çó¸övbÖеÄsqlÓï¾äµÄд·¨£¬´ÎsqlÓï¾äµÄÓ÷¨ÊÇ·ÖÒ³³ÌÐò ÎÒдµÄÈçÏ£ºÆäÖÐAÊÇÓÃÀ´½ÓÊÕÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£¬BÊÇÓÃÀ´½ÓÊÕÏÔʾµÄµ±Ç°µÄÒ³Ãæ. sqltext="select top A * from log where id not in(select top ( ......