Re: query issue

"Guido Konsolke" <GK_at_oblivion.com> wrote in message news:1075286028.798968_at_news.thyssen.com...
| "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
|
|

additional hint: use the max(id) in a subquery

• mcs