1
Hello I have a table in the database that in it are stored several times. I am making a query only that this giving error.
Consultation:
select proximo from (select localizacao.horario as proximo from localizacao where localizacao.horario > CURRENT_TIME LIMIT 1) as tb_proximo, ultimo FROM (select localizacao.horario as ultimo from localizacao where localizacao.horario < CURRENT_TIME) as tb_ultimo;
Error:
2 errors were found during analysis.
This type of clause was previously parsed. (near "FROM" at position 148)
Unrecognized statement type. (near "FROM" at position 148)
Yes the mood is that, it worked, thank you very much!
– Gabriel Rabelo
You’re welcome! Give the answer as sure ;)
– João Martins