from 成绩;
where 分数>67;
order by 分数(一个字段名而已) 常用函数
?sign (-9) -1
?sign (9) 1
?sign (0) 0
?sqrt (100) 10.00
?pi() 3.14
?round (pi (),9) 3.141592654 ?int (6.89) 6
?ceiling (-2.9) -2
?ceiling (2.9) 3
?floor (2.9) 2
?floor (-2.9) -3
a=56.574839
?round (a,3) 56.575
?round (a,-2) 100
?round(a,-1) 60
?mod(10,4) 2
?10%3 1