select count(*),count(decode(to_char(hiredate,'yyyy'),'1981',ename))"1981"
,count(decode(to_char(hiredate,'yyyy'),'1982',empno)) "1982"
,count(decode(to_char(hiredate,'yyyy'),'1983',empno)) "1983" from jagan;
,count(decode(to_char(hiredate,'yyyy'),'1982',empno)) "1982"
,count(decode(to_char(hiredate,'yyyy'),'1983',empno)) "1983" from jagan;
No comments:
Post a Comment