osa logo
OSA Home
Start Here
Data Overview
Known Issues
the Surveys
Coverage Maps
Schema browser
Data access
Login
Archive Listing
GetImage
MultiGetImage
Region
Freeform SQL
CrossID
SQL Cookbook
Q&A
Glossary
Release History
Gallery
Publications
Monitor
Downtime
Links
osa logo bottom
IFA     ROE
Home | Overview | Browser | Access | Login | Cookbook 
  OSA logo

Introduction to SQL

Queries are carried out on the OSA 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 vhsSource

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

to give the full query

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

An introductory SQL tutorial can be found here.



Home | Overview | Browser | Access | Login | Cookbook
Listing | FreeSQL
Links | Credits

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

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