title: BigQuery SQL how to get total count when using LIMIT
body: <p>If I use <code>LIMIT 10</code> in a SQL query (using BigQuery), is there a way to also return the total count?</p>
  
  <p>For example, 100 rows exist. How can I query to return the first 10 but also display to users how many rows are available in total without doing a separate <code>count(id)</code> aggregate query?</p>