KB-20214: SQL function to calculate maximum, minimum, and average values.
Question: How can I set an SQL query (Access database) to retrieve the tag’s maximum, minimum, and average values? Solution: To do so, you must use MAX, MIN, and AVG…
Question: How can I set an SQL query (Access database) to retrieve the tag’s maximum, minimum, and average values? Solution: To do so, you must use MAX, MIN, and AVG…
Question: How can I have an SQL query return values every ten minutes, even when the Historic keeps recording these values every second? Example: 4h 30min – tag1 = 1…