Error Code: 1242. Subquery returns more than 1 row: for carretera Glength

ahmed trad 0
Viewed 16
SELECT c1.matricula, GLength(c1.geometry) as longitud 
FROM carreteras c1
WHERE GLength(c1.geometry) = (
    SELECT GLength(c2.geometry) 
    FROM carreteras c2
);
mysql
1 Answers

When the subquery returns more than one row, you have to use IN:

SELECT c1.matricula, GLength(c1.geometry) as longitude
FROM carreteras c1
WHERE GLength(c1.geometry) IN (
    SELECT GLength(c2.geometry)
    FROM carreteras c2
);

or ANY:

SELECT c1.matricula, GLength(c1.geometry) as longitude
FROM carreteras c1
WHERE GLength(c1.geometry) = ANY (
    SELECT GLength(c2.geometry)
    FROM carreteras c2
);
Rubén Pérez0
Related