Blogs RSS Blogs RSS Forums RSS Forums RSS
•
•
•
•
Showing results 1 to 1 of 1
Search took 0.00 seconds. Posts Made By: arvind209
Save these search results for 24 hours
Forum: Oracle Oct 1st, 2008
Replies: 2
Views: 2,358
Posted By arvind209
Re: Query to display no of employees in the department 10, 20,30 in a single row

select '10 '||sum(a)||' 20 '||sum(b)||' 30 '||sum(c) "Dept vs count(*)" from(select decode(deptno,10,count(Sal)) a, decode(deptno,20,count(Sal)) b, decode(deptno,30,count(Sal)) c from emp group by...
Showing results 1 to 1 of 1

 
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 4:11 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC