query issue

From: curwen <josephcurwen_at_despammed.com>
Date: 28 Jan 2004 01:06:44 -0800
Message-ID: <cc68edc4.0401280106.39af56ff@posting.google.com>

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 Received on Wed Jan 28 2004 - 03:06:44 CST