SQL LEFT JOIN

SQL LEFT JOIN clause is used to select all the matched records from the left side table, regardless if it has matched records in the right side table or not.

Read more

SQL Alias

SQL Alias is used to organize the output, to make it easy to read and more meaningful. SQL Alias can be used with database tables or database table columns.

Read more

SQL HAVING

The SQL HAVING clause is similar to SQL WHERE clause. The difference is that the SQL HAVING clause is used in aggregate functions but the SQL WHERE clause cannot be used in aggregate functions.

Read more

SQL IN

The SQL IN operator is used to search from a list of values in an SQL WHERE clause. The list could be the result of an SQL SELECT query.

Read more

SQL GROUP BY

The SQL GROUP BY statement is used along with the aggregate functions to group the result dataset by one or more database table columns.

Read more

SQL NOT

The SQL NOT operator is used to invert the result of an expression.

Truth table for SQL NOT:

Expression Value NOT
True False
False True
Unknown Unknown

Read more