Count function inside a decode function,
539790Jul 23 2008 — edited Jul 24 2008Hi 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