Home | Overview | Browser | Access | Cookbook | Links | Credits

Introduction to SQL

Simple queries are made up of 3 basic commands: select, from and where.

select - list the parameters you wish to extract (separated by commas) e.g. select ra,dec,muAcosD,muD

from - list the table names you need to access e.g. from source

where - provide any constraints e.g. where dec < -10 and dec > -20

to give the full query

select ra,dec,muAcosD,muD
from source
where dec < -10 and dec > -20

An introductory SQL tutorial can be found here.