Database (aggregate function)

Select ABS (-5)--absolute value is displayed in the result box
Print ABC (-5)--message box display
Select Code,xingming,abs (Yuwen) as Yuwen from Xhushengbiao
Select Code,xingming,yuwen from Xhushengbiao where ABS (Yuwen) >95

Select *from Xhushengbiao where ABS (Yuwen) >95
Select CEILING (1.3)
Select CEILING (shuxue) Form Xueshengbiao where (shuxhe-ceiling (Shuxue))!=0
--fractions minus the upper limit are not equal to zero
Select CEILING (shuxue) Form Xueshengbiao where CEILING (Shuxue) >=90
The upper limit of mathematics is greater than or equal to 90
Select Floor (shuxue) Form Xueshengbiao where code=8

Select ' This is ' +xingming+ ' age squared: ', POWER (aqe,2) from Xueshengbiao

Select POWER (3,2)--Indicates that 3 of the 2 times equals a few to return a few

Select ROUND (2.55,2)--the number after which the argument is the first to be rounded to the decimal point

Select Shuxue,power (shuxue,2) as Shehou from Xueshengbiao

Select SQRT (4)--square root
Select Square (4)--square

Database (aggregate function)