Re: query issue

> JC, there is no guarantee that the order that the rows display in is
> the same as the insert order since Oracle is going to look for and
> insert into blocks with free space in them. Guido, pointed you at the
> solution: you have to use the max progressive id for a numb fk1 value
> combination to find the last inserted value pair.
>
> HTH -- Mark D Powell --

ok, do you mean something like this:

select * from numbers where n_id in
(select max(n_id) from numbers group by n_number);

in your opinion is there any way to avoid the nested query? jc Received on Thu Jan 29 2004 - 10:35:03 CET