I have a database that has 50,000 records from a remote field device. These readings are every 16 seconds, and are stored as such in the database. What I am wondering is if there is a query that I can do that will return the reading at every hour? I am currently running the query with the device ID, and getting all readings. The column for date and time is the datetime format.