title: Skip/Take with Spark SQL
body: <p>How would one go about implementing a skip/take query (typical server side grid paging) using Spark SQL. I have scoured the net and can only find very basic examples such as these here:
  <a href="https://databricks-training.s3.amazonaws.com/data-exploration-using-spark-sql.html" rel="nofollow">https://databricks-training.s3.amazonaws.com/data-exploration-using-spark-sql.html</a></p>
  
  <p>I don't see any concept of ROW_NUMBER() or OFFSET/FETCH like with T-SQL. Does anyone know how to accomplish this?</p>
  
  <p>Something like:</p>
  
  <pre><code>scala &gt; csc.sql("select * from users skip 10 limit 10").collect()
  </code></pre>