SQL INNER JOIN clause is used to select data from 2 (or more) tables, at least one match in both tables.
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.
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.
The SQL BETWEEN operator is used to select data within a range between 2 values.
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 operator is used to search a table column based on a pattern.
The SQL GROUP BY statement is used along with the aggregate functions to group the result dataset by one or more database table columns.
This article is used to gather data type differences information for people who are porting SQL from SQL Server to Oracle or vise versa.
The differences are list in the following table. If you have more to put into, please leave a comment here and we will include it in the table.
The SQL NOT operator is used to invert the result of an expression.
Truth table for SQL NOT:
The SQL Avg() function returns the average value of a numeric column.