学习笔记
1 count 去掉重复
select count(distinct sal) from table1
2分组函数省略null值
select count(nvl(sal,0)) from table1
3 round
4外链接 + 补充空行
select sal from a(+),b
学习笔记
1 count 去掉重复
select count(distinct sal) from table1
2分组函数省略null值
select count(nvl(sal,0)) from table1
3 round
4外链接 + 补充空行
select sal from a(+),b