Description\n-----------\n\nA row subquery is a subquery returning a single row, as opposed to a scalar subquery, which returns a single column from a row, or a literal.\n\nExamples\n--------\n\nCREATE TABLE staff (name VARCHAR(10), age TINYINT);\n\nCREATE TABLE customer (name VARCHAR(10), age TINYINT);\n\nINSERT INTO staff VALUES ('Bilhah',37), ('Valerius',61), ('Maia',25);\n\nINSERT INTO customer VALUES ('Thanasis',48), ('Valerius',61), ('Brion',51);\n\nSELECT * FROM staff WHERE (name,age) = (SELECT name,age FROM customer WHERE name='Valerius');\n+----------+------+\n| name     | age  |\n+----------+------+\n| Valerius |   61 |\n+----------+------+\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins-subqueries/subqueries/subqueries-row-subqueries