oNice

ÕªÒª£º -- havingÇ°Ãæ±ØÐëÓÐgroup byselect e.deptno ,sum(e.sal) as sum_sal ,min(e.sal) as min_sal ,max(e.sal) as max_sal ,avg(e.sal) as avg_sal ,count(e.ename) as c ÔĶÁÈ«ÎÄ

ÕªÒª£º ¹ØÁªµÄ±¾ÖÊ:´ÓÒ»ÕűíÒÀ´ÎÈ¡Ò»ÌõÊý¾ÝºÍÁíÒ»ÕűíÿһÌõÊý¾Ý½øÐÐÆ¥Åä ÄÚ¹ØÁª inner join (inner¿ÉÊ¡ÂÔ) -- Ö»ÏÔʾ¹ØÁªµÄÉϵÄÊý¾ÝÍâ¹ØÁªÓÐÈýÖÖ×óÍâ left join -- Ö÷±íÊý¾Ý²»¶ªÊ§(¹Ø¼ü×Ö×ó±ßµÄ±í)ÓÒÍâ right join -- Ö÷±íÊý¾Ý²»¶ªÊ§(¹Ø¼ü×ÖÓұߵıí)È«Íâ full ÔĶÁÈ«ÎÄ

ÕªÒª£º dual±í¿ÉÒÔ½øÐÐÔËËãselect * from dual; ËãÊýÔËËã + - * /select 5 + 6 as aaa ,6 - 3 as bbb ,5 * 7 as ccc ,9/2 as ddd from dual; ±í²éѯ¿ÉÒÔÈa56爆大奖在线娱乐â¼Ó ×Ö¶Î(¹Ì¶¨Öµ)³õѧÕßÈÝÒ×±¨´íµÄµØ·½£ºÍü¼Çд±ðÃû£¬±ØÐë¸ø ÔĶÁÈ«ÎÄ

ÕªÒª£º -- alter table ¸ü¸Ä±í-- modify ÐÞ¸Ä-- add constraint Ìí¼ÓÔ¼Êø-- not null ²»Îª¿Õ-- unique Ψһ-- check ¼ì²é-- values Öµ-- default ĬÈÏ-- primary key Ö÷¼ü-- foreign key Íâ¼ü - ÔĶÁÈ«ÎÄ

ÕªÒª£º ddl ÊǶԱí½á¹¹µÄ²Ù×÷ create£¨´´½¨£©ÃüÁî¡¢alter£¨Ð޸ģ©ÃüÁî¡¢drop£¨É¾³ý£©dml ÊǶԱíÊý¾ÝµÄ²Ù×÷ insert£¨²åÈ룩ÃüÁî¡¢update£¨¸üУ©ÃüÁî¡¢delete£¨É¾³ý£© alter ÐÞ¸Äadd Ìí¼Ómodify ÐÞ¸Ädrop ɾ³ýrename ÖØÃüÃû ÐÞ¸Ä -- alter t ÔĶÁÈ«ÎÄ

ÕªÒª£º ÅÅÐò order by ĬÈÏÕýÐò asc µ¹Ðò desca56爆大奖在线娱乐×Ö¶ÎÓÒÉÏ½Ç µ¥»÷¿ÉÒÔÅÅÐò(ÕýÐòµ¹Ðò¶¼¿ÉÒÔ) -- °´Ò»¸ö×ֶεÄÅÅÐò ĬÈÏÕýÐòselect * from emp e order by e.sal;-- ¼ÓÉÏÕýÐò¹Ø¼ü×ÖÒ²ÊÇ¿ÉÒÔµÄselect * from emp e order by e.s ÔĶÁÈ«ÎÄ

ÕªÒª£º -- ɾ³ý±ídrop table -- ½¨±ícreate table -- ±í×¢ÊÍcomment on table ... is ...-- ×Ö¶Î×¢ÊÍcomment on column ... is ... -- ²éѯselect * from -- Ôö¼Óinsert into ... values ÔĶÁÈ«ÎÄ

ÕªÒª£º -- Óï·¨ select * |ÁÐÃû|±í´ïʽ -- 5 from ±íÃû -- 1 where Ìõ¼þ -- 2 group by ÁÐÃû -- 3having Ìõ¼þ -- 4 order by ÁÐÃû [asc/desc] -- 6 ±¨´í ²»ÊÇgroup by±í´ïʽ²éѯ×ֶθú·Ö×é×ֶβ»Ò»Ö·Ö×é×Ö¶a56爆大奖在线娱乐ªÓë²éѯ ÔĶÁÈ«ÎÄ

ÕªÒª£º 1.Õâ¸ö°²×°·½·¨²»ÐèÒªÅäÖû·¾³±äÁ¿ 2. 3. 4.½øÈëcmd£¬ÊäÈëpython -v ÔĶÁÈ«ÎÄ

ÕªÒª£º 1.Ë«»÷°²×°°ü 2.µã»÷next 3.Ñ¡Ôñ°²×°Ä¿Â¼ºóµã»÷next½øÈëÏÂÒ»²½ 4.¸ù¾ÝÄãµçÄÔµÄʵ¼ÊÇé¿öÑ¡Ôñ°²×°32λ»¹ÊÇ64λ 5.¹´Ñ¡ .py ºó¼´¿Éµã»÷next½øÈëÏÂÒ»²½ 6.ĬÈÏ£¬Ö±½Ónext 7.°²×°Íê³Éºó£¬µã»÷finish 8.´ò¿ªÈí¼þ£¬ÕâÀïÊÇÎÊÄãÒª²»Òªµ¼ÈëpycharmÅäÖã¬Ö±½ÓµãĬÈÏÈ»ºó ÔĶÁÈ«ÎÄ