SQL INNER JOIN Keyword The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns in both tables. SQL INNER JOIN Syntax or: PS! INNER JOIN is the same as JOIN. Demo Database In this tutorial we will use the well-known Northwind sample database. Below is…


SQL joins are used to combine rows from two or more tables. SQL JOIN An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them. The most common type of join is: SQL INNER JOIN (simple join). An SQL INNER JOIN returns all rows from…


SQL aliases are used to temporarily rename a table or a column heading. SQL Aliases SQL aliases are used to give a database table, or a column in a table, a temporary name. Basically aliases are created to make column names more readable. SQL Alias Syntax for Columns SQL Alias Syntax for Tables Demo Database…


The BETWEEN operator is used to select values within a range. The SQL BETWEEN Operator The BETWEEN operator selects values within a range. The values can be numbers, text, or dates. SQL BETWEEN Syntax Demo Database In this tutorial we will use the well-known Northwind sample database. Below is a selection from the “Products” table:…


The IN Operator The IN operator allows you to specify multiple values in a WHERE clause. SQL IN Syntax Demo Database In this tutorial we will use the well-known Northwind sample database. Below is a selection from the “Customers” table: CustomerID CustomerName ContactName Address City PostalCode Country 1 Alfreds Futterkiste Maria Anders Obere Str. 57…


SQL UPDATE Statement The UPDATE statement is used to update records in a table. The SQL UPDATE Statement The UPDATE statement is used to update existing records in a table. SQL UPDATE Syntax UPDATE table_name SET column1=value1,column2=value2,… WHERE some_column=some_value; Note Notice the WHERE clause in the SQL UPDATE statement! The WHERE clause specifies which record…


SQL INSERT INTO Statement The INSERT INTO statement is used to insert new records in a table. The SQL INSERT INTO Statement The INSERT INTO statement is used to insert new records in a table. SQL INSERT INTO Syntax It is possible to write the INSERT INTO statement in two forms. Demo Database In this…


SQL ORDER BY Keyword The ORDER BY keyword is used to sort the result-set. The SQL ORDER BY Keyword The ORDER BY keyword is used to sort the result-set by one or more columns. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in a descending order, you…


SQL AND & OR Operators The AND & OR operators are used to filter records based on more than one condition. The SQL AND & OR Operators The AND operator displays a record if both the first condition AND the second condition are true. The OR operator displays a record if either the first condition…


SQL WHERE Clause The WHERE clause is used to filter records. The SQL WHERE Clause The WHERE clause is used to extract only those records that fulfill a specified criterion. SQL WHERE Syntax Demo Database In this tutorial we will use the well-known Northwind sample database. Below is a selection from the “Customers” table: CustomerID…