readthefuckingmanual.net

[SOLVED] Error: ORA-01427: single-row subquery returns more than one row

Error added: 2021-02-19T15:19:40Z

0 people waiting for the answer...

1 answers found.

Answer 2648 (0.0% helpful)

The problem I'm having is that the query runs fine in SQL Developer and returns the correct data, the subqueries only return a single row, but yet I get this error when running the same query in NodeJS.

My query is this (anonymised):

SELECT A, B , C FROM T1 WHERE PS = (SELECT SS FROM T2 WHERE I = :param) AND DD = (SELECT MAX(DD) FROM T1 WHERE PS = (SELECT SS FROM T2 WHERE I = :param))
Permalink

Add an answer/solution

If you know the answer, please add your own solution below.
If you don't know, but find out later, please come back and share your answer - there will be other people struggling with this too.


Please enter 61948 here

If you want to be notified via email when this is solved, enter your email address here: