title: BigQuery skip, take for data grid paging
body: <p>I need to skip records, take a certain amount of records and get the total number of records for my data grid using BigQuery. I know how to take records (the page size):</p>
  
  <pre><code>   SELECT * FROM `my_table` where name='sonic' LIMIT 10
  </code></pre>
  
  <p>Now I need to skip "x" amount of records based on what page the user is on. I can this data, I just dont know the big query syntax to do it. Sql Server does it this way </p>
  
  <pre><code>   SELECT col1, col2, ...
     FROM ...
     WHERE ... 
     ORDER BY -- this is a MUST there must be ORDER BY statement
      -- the paging comes here
     OFFSET     10 ROWS       -- skip 10 rows
  </code></pre>
  
  <p>I also need the total number of records for the query to display a total records count.</p>
  
  <p>How do I do this using big query? Thanks</p>