We use the SQL SELECT statement to retrieve the name of the first (LIMIT 1) user who still has their "have we retrieved this user" value set to zero.
Usamos la sentencia de SQL SELECT para recuperar el nombre del primer usuario (LIMIT 1) que aún tiene su valor de "hemos recuperado ya este usuario" a cero.
Change the SQL by adding the line below at the end of the SQL Select statement.
The SQL SELECT statement, which DatabaseSpy 2013 automatically builds to query the database, is displayed in a SQL editor pane at the top.
La instrucción SELECT de SQL, generada automáticamente por DatabaseSpy 2013 para consultar la base de datos, aparece en el panel superior del editor SQL.
Results The Results step displays the SQL Select statement for your query.
The first line of the rule defines the SQL SELECT statement used to query on the "iot/tempSensors/ " topic.
La primera línea de la regla define la declaración SQL SELECT, que se usa para consultar el tema "iot/tempSensors/ ".
Potentially sensitive or inappropriate content
Examples are used only to help you translate the word or expression searched in various contexts. They are not selected or validated by us and can contain inappropriate terms or ideas. Please report examples to be edited or not to be displayed. Potentially sensitive, inappropriate or colloquial translations are usually marked in red or in orange.