title: Database related query
body: <p>In one of the interview, I was asked a question on sql query.
  The query is for employee table </p>
  
  <pre><code>ID     Name     Salary
  1      emp 1    10000
  2      emp 2    20000
  3      emp 3    30000
  4      emp 4    40000
  ...
  </code></pre>
  
  <p>I have to update employee salary as say if it is below 10000 increment by 500
  if it is between 10000 to 20000 update by 600
  if it is between 20000 to 30000 update by 700
  and continuous till last record in the table.
  There's hundreds of thousands of rows in the table.</p>
  
  <p>How to create script for this?</p>