Use SQL for function Query

[Ceil] Function

"Select Mgr, Mgr/100, Ceil (Mgr/100) from Scott. EMP;

Function usage: Ceil (n), which is the smallest integer greater than or equal to the value n.

[FLOOR] Function

Select Mgr, Mgr/100, floor (Mgr/100) from Scott. EMP;

Function usage: floor (n), which is the maximum integer less than or equal to the value n.

[Mod] Function

Select Mgr, MOD (MGR, 1000), MOD (MGR, 100), MOD (MGR, 10) from Scott. EMP;

Function usage: Mod (m, n), returns the remainder of m after division of N.

[Power] Function

Select Mgr, power (MGR, 2), power (MGR, 3) from Scott. EMP;

Function usage: Power (m, n), N to the power of M.

[Round] Function

Select Mgr, round (Mgr/100,2), round (Mgr/1000,2) from Scott. EMP;

Function usage: round (m, n), rounding, retaining n digits

[Sign] Function

Select Mgr, mgr-7800, sign (mgr-7800) from Scott. EMP;

Function usage: Sign (n ). N> 0, 1; n = 0, 0; n <0,-1.

[AVG] Function

Select AVG (MGR) average salary from Scott. EMP;

Function usage: AVG (field name), calculate the average value. The field must be numeric.

[Count] Function

Select count (*) Total number of records from Scott. EMP;

"Select count (distinct job) Total number of job categories from Scott. EMP;

Function usage: Count (field name) or count (*), count the total number.

[Min] Function

Select min (SAL) minimum salary from Scott. EMP;

Function usage: min (field name), used to calculate the minimum number of numeric fields.

[Max] Function

Select max (SAL) highest salary from Scott. EMP;

Function usage: max (field name), used to calculate the maximum number of numeric fields.

[Sum] Function

Select sum (SAL) Salary sum from Scott. EMP;

Function usage: sum (field name) to calculate the sum of Numeric Fields