SQL Syntax – Page 2 – SQL Tutorial

SQL LEFT JOIN

October 31, 2011November 2, 2010 by admin

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.

SQL INNER JOIN

October 31, 2011October 29, 2010 by admin

SQL INNER JOIN clause is used to select data from 2 (or more) tables, at least one match in both tables.

SQL Alias

November 1, 2011October 22, 2010 by admin

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.

SQL HAVING

November 1, 2011September 14, 2010 by admin

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.

SQL BETWEEN

November 2, 2011September 11, 2010 by admin

The SQL BETWEEN operator is used to select data within a range between 2 values.

SQL IN

November 2, 2011September 9, 2010 by admin

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.

SQL LIKE

November 2, 2011September 2, 2010 by admin

SQL LIKE operator is used to search a table column based on a pattern.

SQL GROUP BY

November 2, 2011August 31, 2010 by admin

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

SQL NOT

November 2, 2011August 11, 2010 by admin

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

SQL Wildcard

November 3, 2011July 25, 2010 by admin

SQL wildcard is used to match on a string pattern with the SQL LIKE operator when we search for data in a database.