4. SQL Basic collation (canonical function)

Canonical function: Absolute value

Select ABS (-5)

Print ABS (-5)

The method to take the absolute value in the table:

Select Code,name,abs (Chinese) as Yuwen from Xuesheng

Select *from Xuesheng where ABS (Chinese) >90

Ceiling, floor

Select Ceiling (math) from xuesheng//ceiling

Select *from Xuesheng where ([weight]-CEILING ([weight]))!=0

Power several times

Select POWER (3,2)-Indicates that the secondary equals a few returns

Select POWER (age,2) from Xuesheng

Select ' This is ' +name+ ' of the Age squared ', POWER (age,2) from Xuesheng

Rounded

Select ROUND (176.2,0)///comma indicates the number to be rounded, followed by a comma to be rounded to several decimal places.

SELECT [Weight],round ([weight],0) as Shehou from Xuesheng

Radical (square root)

Select SQRT (4)//result is 2

Select SQUARE (4)//result is 16

4. SQL Basic collation (canonical function)