Database Series Learning (vi)-mathematical functions of functions

1. Absolute value

2. Random number

(1) without seeds

(2) with seeds

3. Rounding

(1) rounding

(2) to find the largest integer

(3) to find the smallest integer

4. Trigonometric Functions

(1) sine, cosine, tangent

(2) Anyway chord, inverse cosine, cut anyway

(3) Two variables of the inverse tangent

(4) A cotangent of two variables

5. Pi

6. Angle system and Radian system

(1) Conversion of radian to angle system

(2) Conversion of angle system to radian system

7. Find the symbol for a number

8. Divide two numbers

(1) Seeking remainder

(2) Seeking divisor

9. Exponent and square root

(1) Index

(2) square root

10. Appendix SQL script, can be directly assigned value paste

--Absolute Value: 1.1Select ABS(-1.1)--Seek index: 4Select Power(2,2)--square Root: 4Select sqrt( -)--find random number: between 0-1Select  Rand()--random number seed: Only one time, the random number is not changedSelect Rand(2) rounded to the maximum integerSelect Ceiling(1.1)--round to smallest integerSelect  Floor(1.9)--Rounding--First Number: value to be rounded--Second number: Calculation accuracy--Result: 1.5600,1.56 is accurate back is the valuationSelect round(1.5555,2)--To find the sine valueSelect Sin(1)--To find the cosine valueSelect Cos(1)--To find the tangent valueSelect Tan(1)--To find the sine value of the inverseSelect ASIN(1)--To find the inverse cosine valueSelect ACOs(1)--To find the inverse tangent valueSelect Atan(1)--ask for the inverse tangent of two variablesSelect ATN2(1,1),Atan(1)--Beg cotangentSelect Cot(1),Cos(1)/Sin(1)--Ask for PiSelect Pi()--conversion of radians to angle system--Angle system = Radian System *180/πSelect degrees(1),1* the/Pi()--Convert angle system to radian system--radian system = Angle System *π/180Select radians(1),1*Pi()/ the--Find Symbols--greater than 0, return 1, less than 0, return-1Select  Sign(-2.2), Sign(4)--To divide the remainder--7 In addition to more than 3 1Select 7%3--To divide and divide the divisor--7 except 3 of 2Select 7/3

Database Series Learning (vi)-mathematical functions of functions