Re: A SQL Question

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