This would be more appropriate in the development forum rather than being in the administration. So I'm taking the liberty to move this thread to the development forum from the administration forum
Life is a journey, not a destination!
While I applaud the general approach of the solution, I would argue against its usage of ROWID. IMHO, ROWID should never be used in production SQL.
I might suggest the following instead:
from the_table a
where CCode || ' ' || DCode || ' ' || LocationCode
=(select min(CCode || ' ' || DCode || ' ' || LocationCode )
Anyway, just a thought,
Click Here to Expand Forum to Full Width