Chapter 2. SELECT Statement
In this Chapter
- Introduction to SELECT
- Syntax of SELECT
- Specifying the Elements Returned (Projection)
- Filtering Query Results (WHERE)
- Joining Tables With Sub-selects
- Paging and Table Limits
- Sort and Other Functions
- Remote and Local Processing
- GUIDs, Social, and Me
- Variable Substitution in the GET Query String
- Extracting HTML Content With XPath
Introduction to SELECT
The SELECT statement of YQL retrieves data from YQL tables. The YQL Web Service fetches data from a back-end datasource (often a Web service), transforms the data, and returns the data in either XML or JSON format. Table rows are represented as repeating XML elements or JSON objects. Columns are XML sub-elements or attributes, or JSON name-value pairs. To try out some SELECT examples and to view the results, run the YQL Console and click the items under "Example Queries" or "Data Tables".