ssa logo
SSA Home
Data Overview
Schema browser
Data access
Radial
Menu query
Freeform SQL
CrossID
Cookbook
Field 287
TWOMPZ
WISExSCOS
Personal SSA
Q&A
Release History
Downtime
Links
Credits
WFAU Home
IFA     ROE
Home | Overview | Browser | Access | Cookbook | Links | Credits   SSA logo

Introduction to SQL

Queries are carried out on the SSA database using SQL (Structured Query Language).

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.



Home | Overview | Browser | Access | Cookbook | Links | Credits
Radial | MenuQuery | FreeSQL | CrossID

WFAU, Institute for Astronomy,
Royal Observatory, Blackford Hill
Edinburgh, EH9 3HJ, UK

mar@roe.ac.uk
16/7/2015