沧海芙蓉

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%数值函数：abs(m)  m的绝对值mod(m,n) m被n除后的余数power(m,n) m的n次方round(m[,n]) m四舍五入至小数点后n位的值（n缺省为0）trunc(m[,n]) m截断n位小数位的值（n缺省为0）%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

SQL> select * from a; A ---------- 1 2 3 4 SQL> select * from b; A B C ---------- ---------- ---------- 1 4 10 2 5 11 5 6 12 6 7 13 SQL>select A.a,B.A,B.b,b.c from A,B where A.a=B.a; A A B C ---------