Re: query issue

"curwen" wrote...
> Hi,
> I'm in deep struggle with query from a huge table:
>
> what I've got is a lot of records like:
>
> _______________
> numb fk1
> _______________
> 1231456 61
> 1231456 62
> 1231456 63
> 1231456 61
>
> from my view I should only get the last record:
> __________
> 123456 61
>
> last has to be intended as inserting order, there's not sorting
 defined on data
> the table has also a progressive id generated by a sequence..
>
> I've tried the the following , but doesn't work:
>
> select distinct numb,fk1
> from <table>
>
> can anybody help, please?
> best regards
> jc

Hi jc,

why don't you use the 'progressive id' you mentioned? Hint for free: MAX().

hth,
Guido Received on Wed Jan 28 2004 - 11:54:27 CET