MariaDB Question:
Download Job Interview Questions and Answers PDF
Tell me what is RIGHT OUTER JOIN in MariaDB?
Answer:
MariaDB RIGHT OUTER JOIN is used to return all rows from right-hand table specified in the ON condition and only those rows from the other table where the joined fields are satisfied the conditions.
MariaDB RIGHT OUTER JOIN is also called RIGHT JOIN.
Syntax:
SELECT columns
FROM table1
RIGHT [OUTER] JOIN table2
ON table1.column = table2.column;
MariaDB RIGHT OUTER JOIN is also called RIGHT JOIN.
Syntax:
SELECT columns
FROM table1
RIGHT [OUTER] JOIN table2
ON table1.column = table2.column;
Download MariaDB Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell me what is the use of ORDER BY clause in MariaDB? | Please explain what is the use of LIKE clause in MariaDB? |