title: Datatable select method ORDER BY clause
body: <p>I 'm trying to sort the rows in my datatable using select method.
  I know that i can say</p>
  <pre><code>datatable.select(&quot;col1='test'&quot;)
  </code></pre>
  <p>which in effect is a where clause and will return n rows that satisfy the condition.</p>
  <p>I was wondering can i do the following</p>
  <p><code>datatable.select(&quot;ORDER BY col1&quot;)</code> ---col1 is the name of the column</p>
  <p>I tried <code>datatable.defaultview.sort()</code> but didnt work</p>
  <p>Any ideas on how to get around this issue.
  thanks</p>