From: sraisdana@l3technology.com   
      
   Thanks Ana,   
   That table was just an example to show what I want,   
   I want one record whenever value of field 1 change   
   while I sorted records based on value of field 2,   
   I know it's not a regular SQL question, anyway I   
   could find a way with Select/Sub-Select and with   
   Lead and Over (they are analytical functions).   
   Thanks anyway - Sasan   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)