query issue

From: curwen <josephcurwen_at_despammed.com>
Date: 28 Jan 2004 01:05:57 -0800
Message-ID: <cc68edc4.0401280105.2a77a7d5_at_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 - 10:05:57 CET