Predicates: To evaluate the true/false VALUES of the UNKNOWN, an expression used is known as Predication. For the search condition of WHERE clause and HAVING clause, and constructs that REQUIRE a Boolean value, PREDICATE is used.

Explain: To obtain a query execution plan with a logical and global plan execution of a STATEMENT, Explain is used.

Join: SQL joins are used to combine rows from two or more tables.

The following are the different types of SQL Joins:

• Inner join
• { LEFT | RIGHT | FULL } OUTER JOIN
• Cross join
• Self join
• Natural join

Predicates: To evaluate the true/false values of the UNKNOWN, an expression used is known as Predication. For the search condition of WHERE clause and HAVING clause, and constructs that require a Boolean value, predicate is used.

Explain: To obtain a query execution plan with a logical and global plan execution of a statement, Explain is used.

Join: SQL joins are used to combine rows from two or more tables.

The following are the different types of SQL Joins: