My query below returns multiple results for RadioNumber 0001. I only want the last result from day before. One record per RadioNumber
select distinct(RadioNumber), MAX(ArrivalDate),Reading
from mytable where ArrivalDate >= DATEADD(day, -1, convert(date, GETDATE()))
Group by Reading,RadioNumber
Results:
RadioNumber | ArrivalDate | Reading
0001 | 09/18/2018 | 123456
0001 | 09/17/2018 | 234567
0002 | 09/18/2018 | 345678
0003 | 09/18/2018 | 456789
