SQL Tutorial - SQLZoo
Tutorials: Learn SQL step by step 0 SELECT basics Some simple queries to get you started 1 SELECT name Some pattern matching queries 2 SELECT from World In which we query the World country …
Sql - SQLZoo
Starting SQL [ MySQL | Oracle | SQL Server | DB2 | Postgres | Ingres ] How to connect to the server and execute SQL statements. Programming with SQL [ SQL in perl on the Web | SQL from Java ] …
AdventureWorks - SQLZoo
Show the CompanyName for James D. Kramer SELECT CompanyName FROM Customer WHERE FirstName='James' AND MiddleName='D.' AND LastName='Kramer' Submit SQL restore default result
SQL Zoo - SQLZoo
SQL Zoo Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.
FUNCTIONS - SQLZoo
SQL Functions Standard SQL functions and some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where possible alternatives are given.
SUM and COUNT - SQLZoo
You might want to look at these examples first Using SUM, Count, MAX, DISTINCT and ORDER BY. Total world population 1. Show the total population of the world. world(name, continent, area, …
Test subquery - SQLZoo
Hack 55 Import Someone Else's Data Hack 62 Issue Queries Without Using a Table Hack 63 Generate rows without tables Hack 70 Combine your queries Hack 72 Extract a subset of the results Hack 78 …
SELECT within SELECT Tutorial - SQL
To get a well rounded view of the important features of SQL you should move on to the next tutorial concerning aggregates. To gain an absurdly detailed view of one insignificant feature of the …
SELECT Reference - SQLZoo
The SELECT line determines which columns to show - in this case name and population, both of which are columns of the bbc table. The WHERE clause determines which rows to show The SELECT …
Using SUM, Count, MAX, DISTINCT and ORDER BY - SQL
SELECT SUM (population), SUM (gdp) FROM world WHERE continent = 'Europe' Submit SQL restore default result