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

SQLÓïÑÔ»ù´¡¿¼ºË(¶þ)(oracle)

 2.¸ù¾ÝOracle Êý¾Ý¿âscott ģʽϵÄemp ±íºÍdept ±í£¬Íê³ÉÏÂÁвÙ×÷£º
      (1) ²éѯ20ºÅ²¿ÃŵÄËùÓÐÔ±¹¤ÐÅÏ¢£»
      (2) ²éѯËùÓй¤ÖÖΪCLERK µÄÔ±¹¤µÄÔ±¹¤ºÅ¡¢Ô±¹¤ÃûºÍ²¿Ãźţ»
      (3) ²éѯ½±½ðCOMM ¸ßÓÚ¹¤×ÊSAL µÄÔ±¹¤ÐÅÏ¢£»
      (4) ²éѯ½±½ð¸ßÓÚ¹¤×ʵÄ20%µÄÔ±¹¤ÐÅÏ¢£»
      (5) ²éѯ10ºÅ²¿ÃÅÖй¤ÖÖΪMANAGER ºÍ20ºÅ²¿ÃÅÖй¤ÖÖΪCLERK µÄÔ±¹¤µÄÐÅÏ¢£»
      (6) ²éѯËùÓй«ÖÚ²»ÊÇMANAGER ºÍCLERK £¬ÇÒ¹¤×Ê´óÓÚ»òµÈÓÚ2000µÄÔ±¹¤µÄÏêϸÐÅÏ¢£»
      (7) ²éѯÓн±½ðµÄÔ±¹¤µÄ²»Í¬¹¤ÖÖ£»
      (8) ²éѯËùÓÐÔ±¹¤¹¤×÷Óë½±½ðµÄºÍ£»
      (9) ²éѯûÓн±½ð»ò½±½ðµÍÓÚ100µÄÔ±¹¤ÐÅÏ¢£»
     (10)²éѯ¸÷Ôµ¹ÊýµÚ¶þÌìÈëÖ°µÄÔ±¹¤ÐÅÏ¢£»
     (11)²éѯ¹¤Áä´óÓÚ»òµÈÓÚ10ÄêµÄÔ±¹¤ÐÅÏ¢£»
     (12)²éѯԱ¹¤ÐÅÏ¢£¬ÒªÇóÒÔÊ××Öĸ´óдµÄ·½Ê½ÏÔʾËùÓÐÔ±¹¤µÄÐÕÃû£»
     (13)²éѯԱ¹¤ÃûÕýºÃΪ6¸ö×ÖĸµÄÔ±¹¤ÐÅÏ¢£»
     (14)²éѯԱ¹¤Ãû×ÖÖв»°üº¬×ÖĸS µÄÔ±¹¤£»
     (15)²éѯԱ¹¤ÐÕÃûµÄµÚ¶þ¸ö×ÖĸΪM µÄÔ±¹¤ÐÅÏ¢£»
     (16)²éѯËùÓÐÔ±¹¤ÐÕÃûµÄǰÈý¸ö×Ö·û£»
     (17)²éѯËùÓÐÔ±¹¤µÄÐÕÃû£¬Èç¹û°üº¬×Öĸs £¬ÔòÓÃS Ìæ»»£»
     (18)²éѯԱ¹¤µÄÐÕÃûºÍÈëÖ°ÈÕÆÚ£¬²¢°´ÈëÖ°ÈÕÆÚ´ÓÏȵ½ºó½øÐÐÅÅÐò£»
     (19)ÏÔʾËùÓÐÔ±¹¤µÄÐÕÃû¡¢¹¤ÖÖ¡¢¹¤×ʺ;©½ò£¬°´¹¤ÖÖ½µÐòÅÅÐò£¬Èô¹¤ÖÖÏàͬÔò°´¹¤×ÊÉýÐòÅÅÐò£»
     (20)ÏÔʾËùÓÐÔ±¹¤µÄÐÕÃû¡¢ÈëÖ°µÄÄê·ÝºÍÔ·ݣ¬°´ÈëÖ°ÈÕÆÚËùÔÚµÄÔ·ÝÅÅÐò£¬ÈôÔ·ÝÏàͬÔò°´ÈëÖ°µÄÄê·ÝÅÅÐò£»
     (21)²éѯÔÚ2Ô·ÝÈëÖ°µÄËùÓÐÔ±¹¤ÐÅÏ¢£»
     (22)²éѯËùÓÐÔ±¹¤ÈëÖ°ÒÔÀ´µÄ¹¤×÷ÆÚÏÞ£¬ÓÓ**Äê**ÔÂ**ÈÕ”µÄÐÎʽ±íʾ£»
     (23)²éѯÖÁÉÙÓÐÒ»¸öÔ±¹¤µÄ²¿ÃÅÐÅÏ¢£»
     (24)²éѯ¹¤×ʱÈSMITH Ô±¹¤ ¹¤×ʸߵÄËùÓÐÔ±¹¤ÐÅÏ¢£»
     (25)²éѯËùÓÐÔ±¹¤µÄÐÕ


Ïà¹ØÎĵµ£º

SQLÃæÊÔ

1.Ò»µÀSQLÓï¾äÃæÊÔÌ⣬¹ØÓÚgroup by
±íÄÚÈÝ£º
2005-05-09 ʤ
2005-05-09 ʤ
2005-05-09 ¸º
2005-05-09 ¸º
2005-05-10 ʤ
2005-05-10 ¸º
2005-05-10 ¸º
Èç¹ûÒªÉú³ÉÏÂÁнá¹û, ¸ÃÈçºÎдsqlÓï¾ä?
            ʤ ¸º
2005-05-09 2 2
2005-05-10 ......

SQL ÖÐ where 1=1 ºÍ 1=0µÄ ×÷ÓÃ

where 1=1ÓÐʲôÓã¿ÔÚSQLÓïÑÔÖУ¬Ð´Õâôһ¾ä»°¾Í¸úûдһÑù¡£
select * from table1 where 1=1Óëselect * from table1ÍêȫûÓÐÇø±ð£¬ÉõÖÁ»¹ÓÐÆäËûÐí¶àд·¨£¬1<>2£¬'a'='a','a'<>'b'£¬ÆäÄ¿µÄ¾ÍÖ»ÓÐÒ»¸ö£¬whereµÄÌõ¼þΪÓÀÕæ£¬µÃµ½µÄ½á¹û¾ÍÊÇδ¼ÓÔ¼ÊøÌõ¼þµÄ¡£
ÔÚSQL×¢Èëʱ»áÓõ½Õâ¸ö£¬ÀýÈçselect * from table1 ......

ORACLE³£ÓÃFAQ

 µÚÒ»²¿·Ö¡¢SQL&PL/SQL
[Q]ÔõôÑù²éÑ¯ÌØÊâ×Ö·û£¬ÈçͨÅä·û%Óë_
[A]select * from table where name like 'A_%' escape ''
[Q]ÈçºÎ²åÈëµ¥ÒýºÅµ½Êý¾Ý¿â±íÖÐ
[A]¿ÉÒÔÓÃASCIIÂë´¦Àí£¬ÆäËüÌØÊâ×Ö·ûÈç&Ò²Ò»Ñù£¬Èç
insert into t values('i'||chr(39)||'m'); -- chr(39)´ú±í×Ö·û'
»òÕßÓÃÁ½¸öµ¥ÒýºÅ±íʾһ¸ö
or ......

SQLÓïÑÔ»ù´¡¿¼ºË(Ò»)(oracle)

 1.ÀûÓÃÏÂÃæµÄ½Å±¾´´½¨BOOK£¬READER ºÍ BORROW ±í£¬²¢Íê³ÉºóÃæµÄÁªÏµ¡£
CREATE TABLE BOOK(
    NO CHAR(8) PRIMARY KEY,
    TITLE VARCHAR2(50) NOT NULL,
    AUTHOR VARCHAR2(20) ,
    PUBLISH VARCHAR2(20),
    PUB_DA ......

SQL SERVER Ò×»ìÏýµÄÊý¾ÝÀàÐÍ

 (1)char¡¢varchar¡¢textºÍnchar¡¢nvarchar¡¢ntext
charºÍvarcharµÄ³¤¶È¶¼ÔÚ1µ½8000Ö®¼ä£¬ËüÃǵÄÇø±ðÔÚÓÚcharÊǶ¨³¤×Ö·ûÊý¾Ý£¬¶øvarcharÊDZ䳤×Ö·ûÊý¾Ý¡£Ëùν¶¨³¤¾ÍÊdz¤¶È¹Ì¶¨ µÄ£¬µ±ÊäÈëµÄÊý¾Ý³¤¶ÈûÓдﵽָ¶¨µÄ³¤¶Èʱ½«×Ô¶¯ÒÔÓ¢ÎĿոñÔÚÆäºóÃæÌî³ä£¬Ê¹³¤¶È´ïµ½ÏàÓ¦µÄ³¤¶È£»¶ø±ä³¤×Ö·ûÊý¾ÝÔò²»»áÒÔ¿Õ¸ñÌî³ä¡£ text´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ