|Introduction to SQL|
|Form Query User Guide|
|SkyServer Traffic Page|
|Contact Help Desk|
|2. A Simple Query|
|3. Common Searches|
|4. More Samples|
|5. Multiple Tables|
|6. Aggregate Fcns.|
|7. Group By|
|8. Order By|
Practice Using Functions
Write queries to answer the astronomy questions in Practice 10 and 11. Use the Schema Browser when you need it.
An Afterthought: Procedures and Constants
In addition to tables, views, and functions, the Schema Browser contains entries for procedures and constants. Procedures, like functions, are mini-programs that the database can execute. Unlike functions, they do not output a single value; rather, they manipulate the inputs passed in to them. Procedures are called with the syntax
Nearly all of the procedures in SkyServer are used by the web server or tools - you will hardly ever use them in your queries. If you ever need them, the Schema Browser will tell you what they do and how to use them.
Constants are, well, constant. They can be displayed and searched just like tables can. See the Schema Browser for a complete description of SkyServer's constants.
You're done! Click Next for the conclusion.