select * from tablenameThere is other query like join, and subquery, etc. But all the yql is read only.
To use the query, you can actually
First, you can use the query console, here. But the query is limited to build in tables from yahoo. Which expose data from yahoo api.
Above is the query console, with build in tables from yahoo, or a more interesting one is here. This actually use table from community made table.
Now you can not just can query yahoo's api, you can query weather data, twitter data, etc
The community made table is hosted at
Which is host at http://datatables.org/ with links to the table hosted on github too.
Another way is to use the REST based interface. For example
Which is a bit of a handful. Which you should write a program to do so.
More can be found in the documentation here.