Streaming queries return unlimited number of rows in CSV format and are cancelled after 30 seconds.
Browser queries return maximum of 1000 rows in HTML format and are cancelled after 30 seconds.

Maximum number of rows to return to the query form:  






Demo queries: click a button and the query will show in the query window.
Holding the mouse over the button will give a short explanation of the goal of the query. These queries are also available on this page.

Counting stars: (produces small result sets, use browser query)
Downloading samples: (produces large result sets, use streaming query)