INTEGER関数

INTEGER関数��数�文字列�日付�時刻を表�整数を定整数�書�を返���。

æ§‹æ–‡

INT[EGER] (数� | 文字列� ) 
æ•°å¼?
組込ã?¿ã?®æ•°å€¤ãƒ‡ãƒ¼ã‚¿åž‹ã‚’è¿”ã?™å¼?ã?§ã?™ã€‚ ã‚‚ã?—引数ã?Œæ•°å¼?ã?§ã?‚れã?°ã€?ã??ã?®å¼?ã?Œå¤§ã??ã?ªæ•´æ•°ã?®åˆ—や変数ã?¸ã?¨ä»£å…¥ã?•れã?Ÿæ™‚ã?¨å?Œã?˜æ•°ã?Œè¿”りã?¾ã?™ã€‚ ã‚‚ã?—引数ã?Œæ•´æ•°ã?®ç¯„囲ã?«å?Žã?¾ã‚‰ã?ªã?„ã?ªã‚‰ã€?エラーã?¨ã?ªã‚Šã?¾ã?™ã€‚ã?¾ã?Ÿã€?引数ã?®å°?数部ã?¯åˆ‡ã‚Šæ?¨ã?¦ã‚‰ã‚Œã?¾ã?™ã€‚
文字列�
文字定数ã?®æœ€å¤§é•·ã‚ˆã‚ŠçŸ­ã?„文字列長ã?®æ–‡å­—列を返ã?™å¼?ã?§ã?™ã€‚ 引数ã?‹ã‚‰å‰?後ã?®ç©ºç™½æ–‡å­—ã‚’å?–り除ã?„ã?Ÿæ®‹ã‚Šã?¯ã€?SQLã?®å®šæ•´æ•°æ›¸å¼?ã?«æ²¿ã?£ã?¦ã?„ã?ªã?‘れã?°ã?ªã‚Šã?¾ã?›ã‚“。 ã?“ã?®æ–‡å­—列ã?¯é•·ã?„文字列ã?§ã?‚ã?£ã?¦ã?¯ã?ªã‚Šã?¾ã?›ã‚“。 ã‚‚ã?—引数ã?Œæ–‡å­—列ã?§ã?‚れã?°ã€?ã??ã?®å¼?ã?Œå¤§ã??ã?ªæ•´æ•°ã?®åˆ—や変数ã?«ä»£å…¥ã?•れã?Ÿã?¨ã??ã?¨å?Œã?˜æ•°ã?Œè¿”りã?¾ã?™ã€‚

関数ã?®çµ?æžœã?¯å¤§ã??ã?ªæ•´æ•°ã?§ã?™ã€‚引数ã?«nullã‚’ã?¨ã‚‹ã?“ã?¨ã?Œã?§ã??ã‚‹å ´å?ˆã€?çµ?æžœã?Œnullã?¨ã?ªã‚‹ã?“ã?¨ã?Œã?‚りã€?引数ã?Œnullã?ªã‚‰è¿”り値ã?¯nullã?§ã?™ã€‚

EMPLOYEE表�ら給与(SALARY)を教育レベル(EDLEVEL)�除��数�一覧を�択���。��除算���数�切り��られ��。��一覧��計算�元��る値や社員番�(EMPNO)���れ��。��一覧�計算�果��順�������。:
SELECT INTEGER (SALARY / EDLEVEL), SALARY, EDLEVEL, EMPNO
FROM EMPLOYEE
ORDER BY 1 DESC