Re: Group by: Not getting expected output

>>And if you wanted to do it efficiently in Oracle 7 without reading the
>>table twice, you could use decode and sign.

OK. But your solution works for this particular case. Mine works with every select criteria. 'Efficiently' can be vague without knowing the details (Indexes, data size & distribution, etc...).

May the force be with you... ;-)

Cheers.

Carlos. Received on Sat May 13 2006 - 04:25:24 CDT