SQL Data Types
The following is a list of general SQL datatypes that may not be supported by all relational databases. Data Type…
Category: Interactive SQL Tutorial
Aggregate Functions
So far, we’ve been looking at queries that retrieve data from single table at a time. Single table queries are…
Try it yourself
OwnerID OwnerLastName OwnerFirstName Address City State Country 1 Jones Bill London UK 2 Smith Bob Paris New…
SQL: ALTER TABLE
The ALTER TABLE statement allows to change the structure of a table after it has been created. New columns can…
SQL: Union Clause
The Union clause allows you to combine the result sets of 2 or more individual queries. Union differs from subqueries…
SQL: LIKE condition
Like is another keyword that is used in the Where clause. It is used to match string pattern values. The…
SQL: DISTINCT clause
Select lets you use the Distinct keyword to eliminate duplicate rows from the query results. Distinct is very useful in queries where…
SQL: SELECT statement
In a relational database, data is stored in tables. The Select statement allows you to retrieve records from one or…
SQL Join
So far, we’ve been looking at queries that retrieve data from single table at a time. Single table queries are…
Database Structure
Here is a full list of tables in the test database. All examples in the SQL tutorial works with the…