2018”N03ŒŽ14“ú

•½¬‚Q‚X”N“x@‹ZpŽm‘æˆêŽŸŽŽŒ±–â‘è@î•ñHŠw•”–å@‡V|‚Q‚S

‡V|‚Q‚S
“X•Ü‚`‚ɍ݌ɂª‚ ‚鏤•i‚ð•\gÝŒÉ‚`h ‚Æ‚µA“X•Ü‚a‚ɍ݌ɂª
‚ ‚鏤•i‚ð•\gÝŒÉ‚ah‚Æ‚·‚éB‚±‚Ì‚Æ‚«A“X•Ü‚`‚¾‚¯‚É
ÝŒÉ‚ª‚ ‚鏤•i‚𒊏o‚·‚éSQL•¶‚Æ‚µ‚āA•s“KØ‚È‚à‚Ì‚Í‚Ç‚ê‚©B

@@@@@@@ÝŒÉ‚` @@@@@@@@@@@@@@Ý—f‚a
„¡„Ÿ„Ÿ„Ÿ„¦„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„¢„¡„Ÿ„Ÿ„Ÿ„¦„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„¢
„ ¤•iID„ @¤•i–¼@@@@@@„ „ ¤•iID„ @¤•i–¼@@@@@@@„ 
„¥„Ÿ„Ÿ„Ÿ„©„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§„¥„Ÿ„Ÿ„Ÿ„©„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§
„ 00001 „ •Ð‘³ƒfƒXƒN@@@@@„ „ 00001 „ •Ð‘³ƒfƒXƒN@@@@@@„ 
„¥„Ÿ„Ÿ„Ÿ„©„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§„¥„Ÿ„Ÿ„Ÿ„©„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§
„ 00002 „ ‚kŒ^ƒfƒXƒN@@@@@„ „ 00003 „ ƒXƒ^ƒ“ƒ_[ƒhƒ`ƒFƒA@@„ 
„¥„Ÿ„Ÿ„Ÿ„©„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§„¥„Ÿ„Ÿ„Ÿ„©„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§
„ 00004 „ ƒGƒRƒmƒ~[ƒ`ƒFƒA@@„ „ 00004 „ ƒGƒRƒmƒ~[ƒ`ƒFƒA@@@„ 
„¥„Ÿ„Ÿ„Ÿ„©„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§„¥„Ÿ„Ÿ„Ÿ„©„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„§
„ 00005 „ ƒtƒ@ƒCƒ‹ƒLƒƒƒrƒlƒbƒg„ „ 00006 „ ‘—ސ®—’I(ˆø‚«o‚µŒ^)„ 
„¤„Ÿ„Ÿ„Ÿ„¨„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„£„¤„Ÿ„Ÿ„Ÿ„¨„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„Ÿ„£



@‡@@SELECT * FROM ÝŒÉA EXCEPT
@@@SELECT * FROM ÝŒÉB;
@‡A@SELECT * FROM ÝŒÉA WHERE ¤•iID
@@@NOT IN (SELECT ¤•iID FROM ÝŒÉB);
@‡B@SELECT * FROM ÝŒÉA WHERE NOT EXISTS
@@@(SELECT ¤•iID FROM ÝŒÉB WHERE
@@@@ÝŒÉA.¤•iID = ÝŒÉB.¤•iID);
@‡C@SELECT DISTINCT * FROM
@@@(SELECT * FROM ÝŒÉA UNION ALL
@@@@SELECT * FROM ÝŒÉB);
@‡D@SELECT ÝŒÉA.¤•iID, ÝŒÉA.¤•i–¼
@@@FROM ÝŒÉA LEFT OUTER JOIN
@@@ÝŒÉB ON@ÝŒÉA.¤•iID = ÝŒÉB.¤•iID
@@@@WHERE ÝŒÉB.¤•iID IS NULL;



‘±‚«‚ð“Ç‚Þ
posted by ƒtƒ@[ƒXƒgƒ}ƒNƒ at 19:23| Comment(0) | H29‹ZpŽmˆêŽŸŽŽŒ±(î•ñHŠw)