SQL Database Sample Comparison

Ignition
1

Hi All

I want compare last 3 sample from SQL database in ascending option (1st>2nd>3rd)

I want to generate alarm based on this in Ignition Vision System

Anybody has tried before this

2

Not much to go on. In most applications the db syntax would be something like this to get the latest three rows (May differ according to db type):

SELECT *
FROM myTable
WHERE some_column = 'some unique attribute'
ORDER BY t_stamp desc
LIMIT 3
2 Likes