SQL Advanced Tutorial

SQL > SQL Advanced

The tutorial shows advanced capabilities of the SQL structured query language.

SQL IN
SQL AND & OR
SQL BETWEEN
SQL LIKE
SQL DISTINCT
SQL GROUP BY
SQL AGGREGATE
SQL CONCAT
SQL SUBSTRING
SQL TRIM
SQL HAVING
SQL ORDER BY
SQL JOIN
SQL OUTER JOIN

Example Data

The following example data is used to illustrated the advanced capabilities of SQL:

Table: Region

region_nbr region_name

100 East Region

200 Central Region

400 West Region

Table: Branch

branch_nbr branch_name region_nbr employee_count

108 New York 100 10

110 Boston 100 6

212 Chicago 200 5

404 San Diego 400 6

415 San Jose 400 3

Table: Branch_Sale

branch_nbr sale_date sale_amount

108 2006-01-01 1000.0000

108 2006-02-07 2500.0000

110 2006-01-01 500.0000

212 2006-01-01 342.0000

404 2006-01-01 200.0000

404 2006-02-03 310.0000

415 2006-01-01 42.0000