Help Please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have:

F1 F2 F3
1 12Oct 2:14
0 12Oct 2:14
0 13Oct 1:15

when is the same day and time I would like a condition that shows just the
record with value in F1 - keep record number 3 and 1

Big Thanks

Dan
 
I think that the solution proposed is on the right track except for one missing bit.

SELECT Max(F1) as F_1, F2, F3
FROM TableName
GROUP BY F2, F3

I think the proposed solution would still return all three records.
 
Back
Top