wsa logo
WSA Home
Start Here
Data Overview
Known Issues
the Surveys
* Coverage Maps
Schema browser
Data access
Login
Archive Listing
GetImage
ColourImage
MultiGetImage
Region
Menu query
Freeform SQL
CrossID
Analysis services
SQL Cookbook
Q&A
Glossary
Release History
non-Survey
Gallery
Publications
Monitor
Downtime
Links
wsa logo bottom
IFA     ROE
Home | Overview | Browser | Access | Login | Cookbook | nonSurvey 
 
  WSA logo

Introduction to SQL

Queries are carried out on the WSA 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,kMag

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

where - provide any constraints e.g. where kMagErr < 0.05

to give the full query

select ra,dec,kmag
from lasSource
where kMagErr < 0.05

An introductory SQL tutorial can be found here.



Home | Overview | Browser | Access | Login | Cookbook | nonSurvey
Listing | Region | MenuQuery | FreeSQL
Links | Credits

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

wsa-support@roe.ac.uk
23/4/2015