SQL Function: INT()

Definition:

Return provided number that truncated to integer.

(Remark:This keyword exists in HKDSE ICT candidates’ reference sheet,but SQL-92 Standard does not include this function.)

---

Command Syntax:

INT(number)

---

Command Example:

Input:

SELECT INT(56.78) AS Result;

Output:

Result
56

---

‘Does this function really exist in exam???’By secondary 6 student