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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.