Pages
Home
Oracle Apps
Downloads
Search This Blog
Friday, September 7, 2012
Query for display the total no.of employees and year wise total no.of employees joined in to company
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;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment