QUESTION:When you meet calculate fraction in oracle

SOLUTION:

1.Check out their values respectively. the use sign of division.

select  count(1) from emp where empno=7369;

select count(1) from emp ;

2.Fusion use  a command by dual table.

select  (select count(1) from emp where empno=7369)/(select count(1) from emp)  from dual;

 

 

posted on 2017-11-13 21:36  杨杨yang  阅读(195)  评论(0编辑  收藏  举报