Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Count function inside a decode function,

539790Jul 23 2008 — edited Jul 24 2008
Hi All,
I've a requirement where I've to fetch a value depending on the count of a column. In that query, I'm using multiple table joins.

For example, if more than one employee's is working for a particular department, then I've to say 'Yes' otherwise 'No'. For this first we have to fetch the count and then we must use decode. So can anyone help me how to do this.

Any help highly appreciated.

--Venky
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2008
Added on Jul 23 2008
10 comments
12,364 views