Minimum retrieval - query 2

In this example, the minimum retrieval mode is used in a manner equivalent to using the SQL Server MIN aggregate. Note that the cycle producing the result is the five-minute phantom cycle just before the query start time.

SELECT TOP 1 DateTime, TagName, CONVERT(DECIMAL(10, 2), Value) AS Value FROM History

WHERE TagName = 'ReactTemp'

AND DateTime >= '2005-04-11 11:31:00'

AND DateTime <= '2005-04-11 11:31:00'

AND wwRetrievalMode = 'Minimum'

AND wwResolution = 300000

The results are: