soalvajavab1_at_yahoo.com wrote:
> The result of the following query is what I like to get:
>
> SELECT MAX(BFP_NUMBER), MAX(METER_NUMBER), UNIT_ID
> FROM BMA_RENTAL_AGREEMENT_UPPER
> GROUP BY UNIT_ID
>
> but I do not need/want to have a group by FUNCTION MAX or any other
> group by function
>
> Is this possible? to do it in other way?
>
>
"I do not want" is not a problem we can solve in this group. Please
explain what is wrong with the answers given and then maybe someone can
come up with a different solution.
--
David Portas
Received on Wed Nov 29 2006 - 15:02:23 CST
