Have a problem where I need to read the On Change ( new rows) from an SQL table (MS SQL) I have managed to read all records. but as the table grows the response grows.
Problem is I want to read a row in table (last) or all the rows written in last 10 seconds ad send out as an MQTT message. Don't want to send out all lines
Query I am using is
Select * from Events
I tried to put a where condition and it won't accept even though the query is valid in Microsoft SQL Workbench thing
SELECT * from Events WHERE EventsID > 12
Ideally the "12" should be the last record of the last read.
(using the gomake/node-red-contrib-mssql-jb SQL driver)