left_dummy.gif (93 bytes)
head_sqlquery.gif (1387 bytes)

 

Help What you need to know about the database Go to example SQL queries that you can modify and run
Define the SQL query in three parts:

1) The first part of the query starts with SELECT, 2) The second part consists of the names of up to 10 table columns to be returned from the database, 3) The third part includes the rest of the query, usually starting with FROM or WHERE

The query already provided on this page returns primary results for the UK published since 1990

Part 1


Part 2

Column Alias (esp. for functions -
see examples)		 Display in output table
1 as
2 as
3 as
4 as
5 as
6 as
7 as
8 as
9 as
10 as

Part 3