SQLã?®æ§‹æ–‡ã?§ã?¯ã?•ã?¾ã?–ã?¾ã?ªæ–‡è„ˆã?§ã€?列ã?®å??å‰?を表å??や相関å??ã?«ã‚ˆã‚Šé™?定ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚
一方ã?§æ–‡è„ˆã?«ã‚ˆã?£ã?¦ã?¯åˆ—å??を表å??や相関å??ã?§é™?定ã?§ã??ã?šã€?å?˜ç´”列å??を使ã‚?ã?ªã?‘れã?°ã?ªã‚‰ã?ªã?„å ´å?ˆã‚‚ã?‚りã?¾ã?™ã€‚ ã??ã?®ã‚ˆã?†ã?ªæ–‡è„ˆã?¨ã?¯ã€?
SELECT c11 AS col1, c12 AS col2, c13 FROM t1 FOR UPDATE of c11,c13ã?¨ã?„ã?†ä¾‹ã?«ã?¦ã€?相関å??ã‚’c11ã?®col1ã?«ä½¿ã?ˆã?¾ã?›ã‚“。ã?ªã?œã?ªã‚‰ã€? c11ã?¯FOR UPDATE ã?«å˜åœ¨ã?™ã‚‹ã?‹ã‚‰ã?§ã?™ã€‚一方ã?§ç›¸é–¢å??ã‚’c12ã?«ä½¿ã?†ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ã?ªã?œã?ªã‚‰ã€?ã?“れã?¯FOR UPDATEã?«å˜åœ¨ã?—ã?ªã?„ã?‹ã‚‰ã?§ã?™ã€‚
[ { table-Name | correlation-Name } . ] SQL92Identifier
-- C.Country ã?¯
相関å??ã?«ã‚ˆã‚Šé™?定ã?•れã?Ÿ
--列å??ã?§ã?™ã€‚
SELECT C.Country
FROM APP.Countries C