trunc 保留小数
sum 求和
wm_concat 字段合并
decode
nvl
sum
count
||
to_char
to_date
substr
trunc (直接截取不做进位处理)、round(截取时要进位)
CONCAT
REPLACE
oracle row_number() over 分析函数 select hgh,row_number() over (order by djsj desc) as rum from t_originallog t where t.djh = '800001585' and rownum=1