From: GK@oblivion.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    
   >   
   > 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   


[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]