Delta retrieval - query 4

For a delta query, if both a wwCycleCount and a Value comparison are specified, the query will return the first number of rows (if available) that meet the value indicated.

SELECT * FROM OpenQuery(INSQL,'SELECT DateTime, Value, Quality, QualityDetail

FROM AnalogHistory

WHERE TagName = "SysTimeSec"

AND wwRetrievalMode = "Delta"

AND Value = 20

AND wwCycleCount = 10

AND DateTime >="2001-07-27 03:00:00.000"

AND DateTime <="2001-07-27 03:20:00.000"

')

The results are: