SQL Query Select time within last hour.
Posted on 2013-11-06
I have the following query:
WHERE (Latitude IS NOT NULL)
The Alias is our trucks, of which we have about 25 of them. They report in a postion, date and time. I want to take and select the record that reflects the last time within the last hour that each truck has reported in. I had this working through Access, but my SQL-Fu is not enough to do it in SQL 2012. Any help is appreciated.