From: anacedent@hotmail.com   
      
   Telus wrote:   
   > A SQL question   
   >   
   > Hi Everybody,   
   > Imagine I have a file with 7 records   
   > and two fields with these data:   
   >   
   > Record1--Field1=1--Field2=10:45pm   
   > Record2--Field1=1--Field2=10:46pm   
   > Record3--Field1=2--Field2=10:47pm   
   > Record4--Field1=2--Field2=10:48pm   
   > Record5--Field1=2--Field2=10:49pm   
   > Record6--Field1=1--Field2=10:50pm   
   > Record7--Field1=1--Field2=10:51pm   
   >   
   > How can I write a SQL to give me   
   > Records 2,5 and 7, fields 1 and 2?   
      
   For what school, course & instructor was this homework assigned?   
   Based upon what criteria/logic are records 2,5,7 the "correct" answer?   
      
   Does the answer change (if so to what?) & why for the following records:   
      
   Record1--Field1=1--Field2=10:51pm   
   Record2--Field1=1--Field2=10:50pm   
   Record3--Field1=1--Field2=10:46pm   
   Record4--Field1=1--Field2=10:45pm   
   Record5--Field1=2--Field2=10:49pm   
   Record6--Field1=2--Field2=10:47pm   
   Record7--Field1=2--Field2=10:48pm   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)