Subquery returns more than 1 row

When subquery returns more than value, you will have to use IN : select * from table . März 20subquery returns more than row 12. Subquery returns more than row in select statement 30. Weitere Ergebnisse von stackoverflow. Im Cache Ähnliche Seiten Diese Seite übersetzen 26. Error 1242: Sub query returns more than row and.

Fortunately, ORA-014is a straightforward query error. A row subquery is a subquery variant that returns one or more rows and can thus return more than one column value. When the subquery returns one or more rows of values, the subquery is only evaluated once and then the row (s) of values is returned to outer query to use.

Row subquery is MySQL specific. ERROR at line 1: ORA-01427: single-row subquery returns more than one row. The group by can return multiple rows so it can not be used in a single row.

Each of the above nested queries return more than one row since . Warning: mysql_fetch_assoc(): supplied argument is not a valid . If SELECT columnFROM treturns just one row, the previous query will work. If the subquery returns more than one row , error 12will occur. For correct work of subquerys on MySQL . You cannot have more than one result.

This is due to the sub-query field. Your sub-query has a Group by that returns an AVG for each student . Which driver are you using and version of it (Ex: PostgreSQL 1): MySQL 5.