select abs(-5)--绝对值 在结果框里显示
print abc(-5)--消息框里显示
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
--分数减去上限的分数不等于零
select CEILING(shuxue) form xueshengbiao where CEILING(shuxue)>=90
数学取上限大于等于90的
select FLOOR(shuxue) form xueshengbiao where code=8
select '这是'+xingming+'年龄的平方:',POWER(aqe,2) from xueshengbiao
select POWER(3,2)--表示3的2次方等于几就返回几
select ROUND(2.55,2)--前面是数 后面参数是代表四舍五入到小数点后的第几位
select shuxue,POWER(shuxue,2)as shehou from xueshengbiao
select SQRT(4) --求平方根
select SQUARE(4)--求平方