MariaDB Question:
Download Job Interview Questions and Answers PDF
Please explain what is LEFT OUTER JOIN in MariaDB?
Answer:
MariaDB LEFT OUTER JOIN is used to return all rows from left-hand table specified in the ON condition and only those rows from the other table where the joined condition is satisfied.
LEFT OUTER JOIN is also called LEFT JOIN.
Syntax:
SELECT columns
FROM table1
LEFT [OUTER] JOIN table2
ON table1.column = table2.column;
LEFT OUTER JOIN is also called LEFT JOIN.
Syntax:
SELECT columns
FROM table1
LEFT [OUTER] JOIN table2
ON table1.column = table2.column;
Download MariaDB Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell us what is the use of COUNT() aggregate function? | Tell me how can you stop replication on all slave servers at the same point in time? |