Select statement

[sambavan]

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


Sam

[chrisrlong]

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:

select contract_number,col_1,col_2,col_3,...,col_n
from the_table a
where CCode || ' ' || DCode || ' ' || LocationCode
=(select min(CCode || ' ' || DCode || ' ' || LocationCode )
from the_table
where contract_number=a.contract_number);

Anyway, just a thought,

- Chris