Error in SQL query

Question

Error in SQL query

Navigation

#1 by (3 votes)

1

Hello, I have a table in the database that has several times stored in it. And I'm just making an appointment that is giving error.

Inquiry:

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)

mysql sql

asked by anonymous 01.10.2018 / 13:12

1 answer

Sort list with Python + Django Doubt about events in a Javascript function [duplicate]

score 3 · Accepted Answer

I think there is some confusion in your query. This ultimo is there more, as well as the 2nd FROM .

Try it this way:

SELECT  (
            SELECT  localizacao.horario AS proximo 
            FROM    localizacao 
            WHERE   localizacao.horario > CURRENT_TIME LIMIT 1
        ) AS proximo
    ,   (
            SELECT  localizacao.horario AS ultimo 
            FROM    localizacao 
            WHERE   localizacao.horario < CURRENT_TIME
        ) AS ultimo