| CARVIEW |
?????̏??????w?肵??SELECT???????s?????FWeb?u???E?U?ŋC?y?Ɋw?Ԏ??HSQL?u???i4?j
?O??́ASELECT???̏????̏???????????܂????B????́A?????̏??????w?肵?āA?ړI?̃f?[?^?????o?????@????????܂??i?ҏW???j
???̋L???͉??????ł??B????o?^?i?????j????ƑS?Ă????????????܂??B
???炭??SELECT?????????????
?@?F???܁A?????܂??Ă??߂łƂ????????܂??B??N??????n?܂??????̘A?ځB?܂???SELECT???̏???????????܂????B???????ł????ł??傤???H
?@?{?A?ڂł͂??ꂩ?炵?炭?̊ԁASELECT???̂??낢??Ȏg?????A?܂?f?[?^?x?[?X????f?[?^?????o?????܂??܂ȕ??@????????Ă????܂??B??1???ł??\???グ?܂??????ASELECT???̍\????SQL?̒??ōł??Ղ????A?????čł???????̂ł??B????́ASQL???̒??ł?SELECT???𗘗p????@????Ȃ葽???Ƃ??????Ƃ??Ӗ????Ă??܂??B???Б?????SQL???????ۂɎ????āA?F????̗͂ɂ??Ă????????B
?uAND?v??uOR?v?𗘗p???ď???????ׂ?
?@????́A?????̏??????w?肵??SELECT???̏?????????????܂??B??3???Ő??????܂??????ASQL???Ō????Ώۂ??u????̍s?f?[?^?̂݁v?ɐ???????ɂ́A???????w?肷??L?[???[?h?uWHERE?v???g?p???܂??B
?@??3??̗?ł́A??????1?????w?肵?܂???ł????B???????A?????̏?????1?????Ƃ͌???܂???B???ۂ̃A?v???P?[?V?????ł́A?Ⴆ?A?w?u?j???v?ł???u30??v?ł???l?x?̂悤?ɕ????̏??????w?肷?邱?Ƃ̕????????ł??傤?B
?@?????̏??????w?肷??ɂ́A?uWHERE?v???1?ڂ̏????ɑ????āuAND?v??uOR?v?Ȃǂ??_?????Z?q???L?q???A??????2?ڂ̏??????w?肵?܂??BAND???g???ꍇ?A?\???͈ȉ??̒ʂ?ɂȂ?܂??B
SELECT ??1, ??2,?c?c FROM ?\?? WHERE ?? ??r???Z?q ?????l AND ?? ??r???Z?q ?????l
?@OR???g???ꍇ?͈ȉ??̒ʂ?ɂȂ?܂??B
SELECT ??1, ??2,?c?c FROM ?\?? WHERE ?? ??r???Z?q ?????l OR ?? ??r???Z?q ?????l
?@?O??2?̏????̊Ԃ?AND??????ƁA?ǂ???????????Ƃ????Ӗ??ɂȂ?A?uOR?v???????2?̏??????ǂ??炩?????Ƃ????Ӗ??ɂȂ?܂??B??????x???}?ŕ\?????}1?̂悤?ɂȂ?܂??B
?}1?@AND??OR?̈Ӗ??????????x???}?@?????Ŏ??????\???͂????܂Ŋ?{?I?Ȃ??̂ł??B1??SQL???̒??ɁAAND??OR?̗????̘_?????Z?q?????邱?Ƃ?AAND??OR???w?肷?邱?Ƃ??ł??܂??B
?@?ł́A??2??ŗp?ӂ???SQL???s???ŁAAND??OR???g????SELECT???????s???Ă݂܂??傤?B?Ⴆ?AEMP?\??DEPTNO?i????j??20?ł???A????JOB?i?E??j??MANAGER?ł???Ј???????????ɂ́A?ȉ??̂悤?ɏ??????w?肵?܂??B
SELECT ename, deptno, job FROM emp WHERE deptno=20 AND job='MANAGER';
?@???s??????}2?̂悤?Ɍ??ʂ??Ԃ??Ă??܂??B
?}2?@AND???g????SELECT???̎??s?????@??ɋ?????SELECT????AND?̕?????OR?ɕς???ƁA?ȉ??̂悤?ɂȂ?܂??B
SELECT ename, deptno, job FROM emp WHERE deptno=20 OR job='MANAGER';
?@???s??????}3?̂悤?ɁADEPTNO?i????j??20?ł???S?Ј??ƁAJOB?i?E??j??MANAGER?ł???S?Ј??̗????????ʂƂ??ĕԂ??Ă??܂??B
?}3?@OR???g????SELECT???̎??s?????_?????Z?q?̗D?揇??
?@AND??OR???w?肷??Ƃ??́A?_?????Z?q?̗D?揇?ʂɒ??ӂ??܂??傤?B?????̏??????ɂ???ẮA???҂??????ʂ??Ȃ??\???????邽?߂ł??B
?@?Ⴆ?A?uDEPTNO?i????j??20?܂???30?v?ł???A???uJOB?i?E??j??MANAGER?v?ł???Ј??i?܂蕔??20??30?̂??ꂼ??̃}?l?[?W???j??????????ꍇ??z?肵?āA???̂悤??SELECT???????s?????Ƃ??܂??傤?B
SELECT ename, deptno, job FROM emp WHERE deptno=20 OR deptno=30 AND job='MANAGER';
?@????SELECT???????s??????}4?̂悤?Ȍ??ʂɂȂ?܂??B
?}4?@AND??OR?̎g???????ԈႦ?????@????20??30?̂??ꂼ??̃}?l?[?W?????????????͂??ł????A???ʂ?????Ɓu????30?̃}?l?[?W???v?Ɓu????20?̎Ј??v??????ł??܂??B?ǂ????Ă??̂悤?Ȍ??ʂɂȂ????̂ł??傤???H
?@???́AWHERE??̒???AND??OR????ׂ?ƁAAND?̘_?????Z???D?悷???Ƃ??????܂肪????̂ł??BAND????OR???ɉ??Z?????????Ƃ??́A???????J?b?R?ł?????܂??B???????邱?Ƃʼn??Z?̗D?揇?ʂ??グ????̂ł??B
?@AND??OR?̗D?揇?ʂ??l????SELECT?????????????ƈȉ??̒ʂ?ɂȂ?܂??B?u????30?܂??͕???20?v?Ƃ??????????J?b?R?ł??????Đ?ɉ??Z?????āA???̌??ʂɑ??āu?E?킪?}?l?[?W???ł???v?Ƃ????????????Z?????܂??B
SELECT ename, deptno, job FROM emp WHERE (deptno=20 OR deptno=30) AND job='MANAGER';
?@???s???ʂ??}5?̂悤?ɂȂ?܂??B????20??30?̂??ꂼ??̃}?l?[?W?????????ł??Ă??邱?Ƃ???????܂??B
?}5?@?J?b?R???g???āAOR???ɉ??Z????????????r???Z?q?̓C?R?[???????ł͂Ȃ?
?@?????܂ł̗?ł́AWHERE??Ɂu??=?l?v?Ƃ????`???A?܂???r???Z?q?Ƃ????????i=?j???g?????`???ŏ??????w?肵?Ă??܂????B???????????w??ɂ͓????̂ق??ɂ??A??Ȃ?i>?j?⏬?Ȃ?i?Ȃǂ̔?r???Z?q?????p?ł??܂??B?\1??WHERE??̏????w??ɗ??p?ł????Ȕ?r???Z?q?Ƃ??ꂼ??̈Ӗ????܂Ƃ߂????̂ł??B
| ??r???Z?q | ?Ӗ? |
|---|---|
| = | ?????? |
| >= | ?ȏ? |
| > | ???傫?? |
| <= | ?ȉ? |
| < | ??菬???? |
| <> ?܂??? != | ???????Ȃ? |
| BETWEEN a AND b | a?ȏ?b?ȉ? |
| NOT BETWEEN a AND b | a?ȏ?b?ȉ????????????? |
| ?\1?@WHERE??̏????w??ɗ??p?ł????Ȕ?r???Z?q | |
?@?Ⴆ?A?u???^??3000?ȏ?̎Ј??v??????????ɂ́A?ȉ??̂悤?ɔ?r???Z?q???g???܂??B
SELECT ename, sal FROM emp WHERE sal >= 3000;
?@???s??????}6?̂悤??3?s?̃f?[?^???Ԃ??Ă??܂??B
?}6?@??r???Z?q?ɕs???????g????SELECT???̎??s?????@?\1?Ɏ????????̂̂ق??ɁA?\2?Ɏ??????悤?Ȕ?r???Z?q???g???܂??B?????̔?r???Z?q???g???A??????̕?????v?????Ȃǂ??\?ɂȂ?܂??B
| ??r???Z?q | ?Ӗ? |
|---|---|
| IN (A, B, C) | A?AB?AC?̂????ꂩ |
| NOT IN (A, B, C) | A?AB?AC?̂?????ɂ???v???Ȃ????? |
| LIKE 'A%' | A?Ŏn?܂?C?ӂ̕????? |
| NOT LIKE 'A%' | A?Ŏn?܂?C?ӂ̕?????ȊO?̂??? |
| LIKE 'A_' | A?Ƃ???ɑ???????1???? |
| NOT LIKE 'A_' | A?Ƃ???ɑ???????1?????ȊO?̂??? |
| IS NULL | NULL?l?ł?????? |
| IS NOT NULL | NULL?l?łȂ????? |
| ?\2?@WHERE??̏????w??ɗ??p?ł????r???Z?q?̒??ł??A???l??r?ȊO?̗p?r?ŕ֗??Ɏg??????? | |
?@IN???Z?q???g???ƁA????̒l?????????w?肵?āA????Ɉ?v????f?[?^???????ł??܂??B?Ⴆ?A??ɋ???????ł́u???傪20??30?v?Ƃ??????????w?肷?邽?߂ɁAOR???g???Ă??܂????B????́AIN???g???Ď??̂悤?ɋL?q???邱?Ƃ??ł??܂??B
SELECT ename, deptno FROM emp WHERE deptno IN (20,30);
?@????SELECT???????s??????}7?̂悤?ɂȂ?܂??B
?}7?@OR???g???ċL?q??????????IN?ŏ?????????SELECT???̎??s?????@???̗?ł́AIN?̂??Ƃ̃J?b?R?ɐ??l?????Ă??܂????A??????????ĔC?ӂ̕?????????????邱?Ƃ??ł??܂??B???̂Ƃ????uIN ('A', 'B', 'C')?v?̂悤?ɁA????????V???O???N?I?[?g?ň͂ޕK?v??????܂??B
?@?????āA??r???Z?qLIKE???g???ƁA ??????̕?????v???????ł??܂??B?Ⴆ?A?ȉ??̂悤??SELECT???ŁA???O???uA?v????n?܂?Ј????????ł??܂??B
SELECT ename FROM emp WHERE ename LIKE 'A%';
?@???s????ƁA?}8?̂悤??2???̃f?[?^?????ʂƂ??Ė߂??Ă??܂??B
?}8?@??r???Z?q??LIKE???g????SELECT???̎??s?????u?f?[?^???Ȃ??v?Ƃ???????
?@?????[?V???i???f?[?^?x?[?X?ł́A?\?̂??ׂẴt?B?[???h?ɕK???l???????Ă???Ƃ͌???܂???B?u?f?[?^???i?[????Ă??Ȃ??v?t?B?[???h??????܂??B
?@?t?B?[???h?ɒl???????Ă??Ȃ????Ƃ??A?uNULL?ł????v?ƕ\?????܂??B?Ⴆ?AEMP?\?́uCOMM?v??͕????????i?[?????ł????A?c?ƐE?ȊO?̎Ј??͕?????????????Ă??܂???B?܂?A?c?ƐE?ȊO?̎Ј???COMM???NULL?ł???ƌ????܂??B
?@NULL?̈????̓????[?V???i???f?[?^?x?[?X?Ǘ??V?X?e???iRDBMS?j?̎?ނɂ???Ă??قȂ?܂????AOracle Database?ł́u0?i?[???j?v?Ƃ??????l??A?X?y?[?X?Ƃ͈قȂ?Ƃ??????ƂɋC??t???Ă????????B???̂??߁A?Ώۂ?NULL?l?ł???ꍇ?A??ʓI?Ȕ?r???Z?͂ł??܂???B
?@?u?f?[?^???i?[????Ă??Ȃ??iNULL?ł???j?v?Ƃ??????????w?肷??ɂ́A?uIS NULL?v???Z?q???g???܂??B????A?u?f?[?^???i?[????Ă???iNULL?ł͂Ȃ??j?v????????Ƃ??Ďw?肷??ꍇ?ɂ́A?uIS NOT NULL?v?Ƃ??????Z?q???g???܂??B
?@?Ⴆ?A?u??????????????Ă???l?iCOMM??NULL?ł͂Ȃ??l?j?v??????????ɂ́A?ȉ??̂悤?ɏ??????w?肵??SELECT???????s???܂??B
SELECT ename, job, comm FROM emp WHERE comm IS NOT NULL;
?@???s????ƁA?}9?̂悤?ɁuJOB?v?uSALESMAN?v?ƂȂ??Ă???4?s?̃f?[?^?A?܂?c?ƐE?̎Ј??̃f?[?^?????邱?Ƃ??ł??܂??B
?}9?@IS NOT NULL???Z?q?𗘗p???āACOMM??NULL?ł͂Ȃ??f?[?^?????o?????????_?????Z?q?uNOT?v
?@?\2??????ƁAIS NOT NULL?̂ق??ɂ??uNOT?v???????Ă????r???Z?q??????܂??B????NOT?́A?P?ɏ????Ƃ??Ďg???????łȂ??AAND??OR?̂悤???_?????Z?q?Ƃ??Ďg?????Ƃ??ł??܂??B?Ⴆ?A?ȉ??̂悤?Ɏg???Ɓu???^??3000?????ł͂Ȃ??v?Ƃ??????????w??ł??܂??B
SELECT ename, sal FROM emp WHERE NOT (sal
?@????SELECT???????s??????}10?̂悤?ɁA???^??3000?????ł͂Ȃ??A?܂苋?^??3000?ȏ?̎Ј??f?[?^?????o???܂??B
?}10?@3000?????Ƃ?????????NOT?Ŕے肵??SELECT???????s?????????@?ȏ?A?????̏??????w?肵??SELECT???????s??????@?ƁA?????w??ɗ??p?ł???_?????Z?q?A??r???Z?q?ɂ??ĉ?????܂????B???Ȃ葽???̔?r???Z?q???Љ?܂??????A???ׂĂ̎??s????????????邱?Ƃ͂ł??܂???ł????B???ЁA???܂??܂Ȕ?r???Z?q???g????SELECT????????Ď??s???Ă݂Ă????????B
?R????---?R?X?g???l???悤
?@WHERE??ŏ??????w?肷??ہA?u???̗?ŏ??????w?肵?Ă??A?ʂ̗?ŏ??????w?肵?Ă??A???????ʂɂȂ?v?Ƃ??????Ƃ?????܂??B?Ⴆ?A????g?p???Ă???EMP?\?ŎЈ??ԍ?7839??KING????̃f?[?^??????????Ƃ??A?uempno=7839?v?Ǝw?肵?Ă??A?uename='KING'?v?Ǝw?肵?Ă????????ʂɂȂ?܂??i?????ł́AKING???????????邩??????Ȃ??Ƃ????\???͍l???Ȃ????Ƃɂ??܂??j?B
?@???̂悤?ȏꍇ?A?ǂ???̗?ŏ??????w?肷??ׂ??ł??傤???H ???̃q???g?ɂȂ?̂??u???s?v??v?Ɓu?R?X?g?v?ł??B
?@???s?v??Ƃ́A?????[?V???i???f?[?^?x?[?X?Ǘ??V?X?e?????ASQL???????s????菇?A?v??????????̂ł??B?????ăR?X?g?Ƃ́A???̏??????s?????߂ɕK?v?ȃ??\?[?X?ʂ𐔒l?????????̂ł??B?ȒP?Ɍ????Ă??܂??ƁA???̒l???傫????Α傫???ق?SQL???̎??s?Ɏ??Ԃ???????Ƃ??????Ƃł??B
?@???s?v??ƃR?X?g?́AAPEX?Ŋm?F?ł??܂??BAPEX?́u???s?v??v?^?u???N???b?N???āA??r???Ă݂܂??傤?Bempno=7839?Ǝw?肵??SQL???̎??s?v??ƃR?X?g?͈ȉ??̐}?̂悤?ɂȂ?܂??B?}???N???b?N????Ɗg??}??\?????܂??B
?@????Aename='KING'?Ǝw?肵??SQL???̎??s?v??ƃR?X?g?͈ȉ??̐}?̂悤?ɂȂ?܂??B???̐}???A?N???b?N????Ɗg??}??\?????܂??B
?@???҂??r????ƁA???s?v??ɈႢ?????邱?Ƃ???????܂??B???̗?ł́A?u?????i?C???f?b?N?X?j?̗L???v?ɂ???Ď??s?v?悪?ς???Ă??܂??B
?@???s?v??̓ǂݕ???R?X?g?A?????č????ɂ??ẮA?????ꂱ?̘A?ڂŐ??????܂????A??{?I?ɂ́u?R?X?g???Ⴂ???????????ǂ??v?ƍl???Ă????????B???̏ꍇ?́Aempno???w?肷??ƃR?X?g???u2?v?Aename???w?肷??ƃR?X?g???u3?v?ł??̂ŁAempno???w?肷????????????ǂ??Ƃ??????ƂɂȂ?܂??B
?@???̗?ł̓f?[?^?ʂ????Ȃ??̂ŁA???s?ɂ????鎞?Ԃ??ׂĂ??قƂ?Ǎ??͂???܂??A?f?[?^?ʂ??????Ă????ƁA???̍??͂ǂ?ǂ?傫???Ȃ?܂??B
?@?A?v???P?[?V?????̖{?ԉғ????n?܂??āA?u?x???v?ƋC?t??????ŁA?????̈???SQL????o???A?Ђ??[????C?????悤?Ƃ???Ƃ????b?͂悭????܂??B???????A??x?{?ԉғ????n?߂??A?v???P?[?V???????ォ??C??????͓̂?????̂ł??BSQL?????????Ƃ??́A?ŏ?????R?X?g???ӎ????ď??????????̂ł??ˁB
?M?ҏЉ?
???{?I???N?? ?I???N???_?C???N?g?????B
?{?X?؏??q?i?????? ?Ȃ????j
?I?????C???Z?~?i?[?̍u?t??A???q?l?ւ̒?āA?Č??̎x???Ȃǂ?S???B?????ɁuOracle SQL?N?C?Y?v?i?ĉj?Ёj??????܂??B
- SQL?Ńf?[?^?𑀍삷??i???⍇???𗘗p????INSERT/????UPDATE/MERGE?j
- SQL?Ńf?[?^?𑀍삷??Ƃ??̕??@?iINSERT?^UPDATE?^DELETE?j
- ???x?ȕ??⍇???̍\??
- ???⍇?????g???????G?ȏ????w??
- ?f?[?^???O???[?v?????ĕ\?????Ă݂悤?i2?j
- ?f?[?^???O???[?v?????ĕ\?????Ă݂悤?i1?j
- ?????̕\????f?[?^?????o???ĕ\????????i2?j
- ?????̕\????f?[?^?????o???ĕ\????????i1?j
- SQL?????g???Ėʓ|?ȏ??????ȒP?ɍς܂???
- SELECT???Ŏ??o?????f?[?^?????H???ĕ\??????
- ?????̏??????w?肵??SELECT???????s????
- ?܂??͂???????I ??{?I??SELECT??????n?߂悤
- SQL???s???????????悤
- SQL?Ƃ͂ǂ????????ꂩ
Copyright © ITmedia, Inc. All Rights Reserved.
?A?C?e?B???f?B?A????̂??m?点
??IT eBook
???ڂ̃e?[?}
RSS?ɂ???
?A?C?e?B???f?B?AID?ɂ???
???[???}?K?W???o?^
??IT?̃??[???}?K?W???́A ???????A???ׂĖ????ł??B???Ѓ??[???}?K?W???????w?ǂ????????B
ITmedia?̓A?C?e?B???f?B?A??????Ђ̓o?^???W?ł??B
???f?B?A?ꗗ | ????SNS | ?L???ē? | ???₢???킹 | ?v???C?o?V?[?|???V?[ | RSS | ?^?c??? | ?̗p??? | ??????