Forum Discussion

Antonio_dsanchez's avatar
Antonio_dsanchez
Copper Contributor
Oct 18, 2023

Error Query SQL multiple select

Hello everyone

I have a problem with the following query

SELECT (SELECT Dato FROM Dato_Medidor WHERE Linea = 'ELFO_006_Oficinas') as 'ELFO_006',
(SELECT Dato FROM Dato_Medidor WHERE Linea = 'ELFO_007_Oficinas') as 'ELFO_007',
(SELECT Dato FROM Dato_Medidor WHERE Linea = 'ELFO_008_Oficinas') as 'ELFO_008',
(SELECT Dato FROM Dato_Medidor WHERE Linea = 'ELFO_009_Oficinas') as 'ELFO_009',
(SELECT Dato FROM Dato_Medidor WHERE Linea = 'ELFO_010_Oficinas') as 'ELFO_010',
Fecha
FROM Dato_Medidor where CONVERT (DATE,Fecha) = CONVERT (DATE,GETDATE ())

 

it returns the following error

 

> Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

 

I want to divide the data that comes from the "Data" field into columns

1 Reply

Sort By
  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Oct 19, 2023

    Antonio_dsanchez 

    > Subquery returned more than 1 value.

    As the error message clearly says. You have to take care that the sub-queries returns only & exact one row. Your filter is may not the right one; exactly I miss a referenc to the current row of table "Dato_Medidor", that can't be right.

     

Resources