SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;
Note: The UNION operator selects...
SQL - INNER JOIN Example
The following SQL statement will return all customers with orders:
Example
SELECT Customers.CustomerName, Orders.OrderIDFROM CustomersINNER JOIN OrdersON Customers.CustomerID=Orders.CustomerIDORDER BY Customers.CustomerName;
Try...
SQL - INNER JOIN Syntax
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name=table2.column_name;
or:
SELECT column_name(s)
FROM table1
JOIN table2
ON table1.column_name=table2.column_name;
PS! INNER...
Different SQL JOINs
Before we continue with examples, we will list the types of the different SQL JOINs you can use:
INNER JOIN: Returns all rows when there is at...
SQL - NOT BETWEEN Operator with Text Value Example
The following SQL statement selects all products with a ProductName beginning with any of the letter NOT BETWEEN 'C' and 'M':
Example
SELECT * FROM ProductsWHERE ProductName NOT BETWEEN 'C' AND 'M';
Try...
SQL - BETWEEN Operator with Text Value Example
The following SQL statement selects all products with a ProductName beginning with any of the letter BETWEEN 'C' and 'M':
Example
SELECT * FROM ProductsWHERE ProductName BETWEEN 'C' AND 'M';
Try...
SQL - BETWEEN Operator with IN Example
The following SQL statement selects all products with a price BETWEEN 10 and 20, but products with a CategoryID of 1,2, or 3 should not be displayed:
Example
SELECT * FROM ProductsWHERE (Price BETWEEN 10 AND 20)AND NOT CategoryID IN (1,2,3);
Try...
SQL - NOT BETWEEN Operator Example
To display the products outside the range of the previous example, use NOT BETWEEN:
Example
SELECT * FROM ProductsWHERE Price NOT BETWEEN 10 AND 20;
Try...
Subscribe to:
Posts (Atom)
