title: How to sort within a sql view
body: <p>I've created a sql view and I need to sort the results of select by using the ORDER BY on 4 fields, but I'm getting message that ORDER BY cannot be used in views unless I use TOP.
  Can someone explain why TOP is needed, and does someone have a workaround for sorting in a sql view?  </p>
  
  <p>Thanks.  </p>