I am a total noob to SQL, maybye my problem can seem basic.
I have a table that collects data from sensors, and i want to only take the new data to send it on a broker.
So, i made a trigger AFTER UPDATE, but I can't find how to select only the last lines added to the sensors table, and what to do with it (put it in a temporary table ?).
Can you help me please ?