title: Oracle select query give priority to column value
body: <p>I have three columns in one table Test </p>
  
  <pre><code>name, type, region
  </code></pre>
  
  <p>Sample values are:</p>
  
  <pre><code>john IT ny
  john SALES ny
  john FINANCE ny
  lisa SALES ny
  lisa FINANCE ny
  </code></pre>
  
  <p>Out of the above condition how can i  give priority 1 to IT, 2 to SALES and 3 to Finance.</p>
  
  <p>I mean for the above sample records it shuld give 2 records</p>
  
  <pre><code>John IT ny
  Lisa SALES ny
  </code></pre>
  
  <p>If employee records are with IT than only those should show, if not than show SALES, if not than show Finance.</p>