Syntax of SELECT

The YQL SELECT statement has the following syntax:

SELECT what FROM table WHERE filter [| function]

The what clause contains the fields (columns) to retrieve. The fields correspond to the XML elements or JSON objects in the data returned by the SELECT. An asterisk (the "*" character) in the what clause means all fields. The table is either the YQL pre-defined or Open Data Table that represents a datasource. (Unlike in SQL, in YQL only one table can be specified.) The filter is a comparison expression that limits the rows returned. The results of the SELECT can be piped to an optional function, such as sort.

In YQL, statement keywords such as SELECT and WHERE are case-insensitive. Table and field names are case sensitive. In string comparisons, the values are case sensitive. String literals must be enclosed in quotes; either double or single quotes are allowed.

Table of Contents