title: Query latest table in the BigQuery dataset
body: <p>I have a dataset containing tables with similar table names ending in yyyymmdd. For example:</p>
  
  <pre><code>myproject:mydataset.Sales20140815
  myproject:mydataset.Sales20140816
  myproject:mydataset.Sales20140817
  myproject:mydataset.Sales20140818
  ...
  myproject:mydataset.Sales20140903
  myproject:mydataset.Sales20140904 
  </code></pre>
  
  <p>Is there any way to write the BigQuery to query the latest table in the dataset (for the above example it is myproject:mydataset.Sales20140904 )?</p>