[[poliburro]]

Esta es un poco más rebuscada:

Código SQL [-]
 
 
       Select Coleta.*
         From Coleta Coleta
    Left Join (
                       SELECT  Max(Data_Hora) As HoraMax, 
                                      Min(Data_Hora)  As HoraMin
                          FROM Coleta 
                           where matricula = '100423' and 
                                     data = #26/05/2008#  
                ) As MaxMin
           On Coleta.DataHora = MaxMin.HoraMax Or
                Coleta.DataHora = MaxMin.DataMin
   Where matricula = '100423' And
            not Coleta.DataHora is null