title: SQL statement optimization issue
body: <p>I want to show rows where region = 'sample' as first rows in result. I mean priority must be higher than another rows and they must be at the top.</p>
  
  <p>I use the SQL below for this result.</p>
  
  <pre><code>SELECT * FROM works Where region = 'sample' UNION Select * FROM works Where region &lt;&gt; 'sample'
  </code></pre>
  
  <p>Is there any optimal way to get result without UNION?</p>