>>>SELECT Date, DatePart(hour,Date) as Hr, reading >>>FROM bin1_empty A >>>WHERE EXISTS( >>>(SELECT Min(Date) as date_B >>>FROM bin1_empty B >>>WHERE DatePart(hour,A.Date) = DatePart(hour,B.Date) >>>HAVING B.Date_B = A.Date) >>>OR EXISTS( >>>SELECT Min(Date) as date_C >>>FROM bin1 C >>>WHERE DatePart(hour,A.Date) = DatePart(hour,C.Date) >>>HAVING C.Date_C = A.Date) >>>>>>
>>SELECT Date, DatePart(hour,Date) as Hr, reading >>FROM bin1_empty A >>WHERE EXISTS( >>SELECT Min(Date) as date_B >>FROM bin1_empty B >>WHERE DatePart(hour,A.Date) = DatePart(hour,B.Date) >>HAVING B.Date_B = A.Date) >>OR EXISTS( >>SELECT Min(Date) as date_C >>FROM bin1 C >>WHERE DatePart(hour,A.Date) = DatePart(hour,C.Date) >>HAVING C.Date_C = A.Date) >>>
SELECT A.Date, DatePart(hour,A.Date) as Hr, A.Reading FROM bin1_empty A WHERE EXISTS( SELECT Min(B.Date) as date_B FROM bin1_empty B WHERE DatePart(hour,A.Date) = DatePart(hour,B.Date) HAVING Min(B.Date) = A.Date) OR EXISTS( SELECT Min(C.Date) as date_C FROM bin1 C WHERE DatePart(hour,A.Date) = DatePart(hour,C.Date) HAVING Min(C.Date) = A.Date)